Drawing on a chart
 

I was wondering if it is possible to draw a horizontal line, or lines, on
a vertical column chart, from left to right, based on the numbers of the
y-axis. I cant just guess where the value is I need the horizontal line to
be specificly located at a certain point on the y-axis. Any
suggestions???????

Drawing on a chart
 

Create a new series with constant values

HTH
--
AP

"Steve" a écrit dans le message de news:
...
I was wondering if it is possible to draw a horizontal line, or lines,
on
a vertical column chart, from left to right, based on the numbers of the
y-axis. I cant just guess where the value is I need the horizontal line
to
be specificly located at a certain point on the y-axis. Any
suggestions???????

Drawing on a chart
 

Jon Peltier has instructions for adding lines to a chart:

http://www.peltiertech.com/Excel/Cha...s.html#AddLine

Steve wrote:
I was wondering if it is possible to draw a horizontal line, or lines, on
a vertical column chart, from left to right, based on the numbers of the
y-axis. I cant just guess where the value is I need the horizontal line to
be specificly located at a certain point on the y-axis. Any
suggestions???????


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html