Hello Wizards

I've got my bar or line graph. Is there a clean way to place a 'standard'
or 'goal' line on the graph. i.e. if I want the goal to be 18.7 can I get
that to be a horizontal line that stands out.

TIA !
Sam

Would using the drawing toolbar to manually insert a line, possibly with some
descriptive text, work?


"Metolius Dad" wrote:

Hello Wizards

I've got my bar or line graph. Is there a clean way to place a 'standard'
or 'goal' line on the graph. i.e. if I want the goal to be 18.7 can I get
that to be a horizontal line that stands out.

TIA !
Sam

see http://peltiertech.com/Excel/Charts/...orzSeries.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Metolius Dad" wrote in message
...
Hello Wizards

I've got my bar or line graph. Is there a clean way to place a 'standard'
or 'goal' line on the graph. i.e. if I want the goal to be 18.7 can I get
that to be a horizontal line that stands out.

TIA !
Sam

The technique Bernard suggested uses a data series, which is not subject to
moving randomly the way a drawing object will do.

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

"Peter Ellis" wrote in message
...
Would using the drawing toolbar to manually insert a line, possibly with
some
descriptive text, work?


"Metolius Dad" wrote:

Hello Wizards

I've got my bar or line graph. Is there a clean way to place a
'standard'
or 'goal' line on the graph. i.e. if I want the goal to be 18.7 can I
get
that to be a horizontal line that stands out.

TIA !
Sam