Inserting a 'Standard'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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/
_______
 
Back
Top