View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Inserting a 'Standard'

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