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" wrote in message
...
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