Inserting a 'Standard'
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 |
Inserting a 'Standard'
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 |
Inserting a 'Standard'
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 |
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 |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com