Thread: Scatter and line charts

Hi
I created the scratter chart and I would like to have another line, showing
the average, will go horizontal across the scratter chart.

Ex: 4,5,6,7,10 are data to create a scratter chart.
The averager of 4,5,6,7,10 is 6.4
May I use 6.4 to create a shot line (or a something )which will go
horizontal across the scratter chart.

Thank you
Chi

Here are some techniques for adding a line to a chart:

http://peltiertech.com/Excel/Charts/AddLine.html

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


"Chi" <Chi@discussions.microsoft.com> wrote in message
news:C8C576E7-3542-477F-9BEC-240BC0D0FC2A@microsoft.com...
> Hi
> I created the scratter chart and I would like to have another line,
> showing
> the average, will go horizontal across the scratter chart.
>
> Ex: 4,5,6,7,10 are data to create a scratter chart.
> The averager of 4,5,6,7,10 is 6.4
> May I use 6.4 to create a shot line (or a something )which will go
> horizontal across the scratter chart.
>
> Thank you
> Chi