Inserting a 'Standard'

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
 
G

Guest

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

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Standard" Line 1
Bar Graph with goal line 1
How do I set a goal line in a bar graph? 3
Creating a goal or target line 1
Creating a custom chart [Excel 2003] 2
Floating Year-To-Date Line 3
2d-Column (Clustered Column) chart with Standard Deviation Bars 1
Need a special bar graph 3

Top