I hadn't noticed the misplaced decimal point in your first post. I can't
think why the plotted values would be off by a factor of 10.

If you send the workbook by private email (make the obvious correction
to the email address), I'll take a look at it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Micayla Bergen wrote:

> The first data series is a calculation of other numbers and the results are 6
> decimal numbers less than 0, i.e. 0.823736, 0.863585 etc. the average is
> 0.772898. the numbers are showing up as 8.23736 and 8.63585 etc whereas the
> average is plotting as 0.772898. the numbers are all formatted the same, i
> dont know why one is showing up as the other.
> (the average was still plotting as only a single dot but i have changed by
> putting the average in multiple cells so it plots as a line.)
>
> "Barb Reinhardt" wrote:
>
>
>>Can you give an example of the data as displayed in Excel?
>>"Micayla Bergen" <MicaylaBergen@discussions.microsoft.com> wrote in message
>>news:18584AF7-9255-4466-92CB-40B43731B088@microsoft.com...
>>
>>>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
>>
>>
>>