Thread: plotted Average
View Single Post
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

Can you give an example of the data as displayed in Excel?
"Micayla Bergen" wrote in message
...
i have a series of data as a line graph, i want my average to be plotted as
well. the average is a single value based on the series not a moving
average.
i have put the average 'series' in and told the chart to plot empty cells
but
nothing has appeared except my single value average and it is not
formatted
the same as the actual series, i.e. the series is 0.895whatever and my
average is 0.774589etc. but the series is showing up as a whole number but
the average is not, i.e. series is 8.95whatever and average is still
0.774589
thanks anyone