PDA

View Full Version : Solved: Setting a benchmark line in an excel bar graph



Bruce T
10-23-2008, 07:03 AM
Hello,

I'm producing performance graphs using excel. e.g bar graphs showing a percentage. Zero to 100% on y axis and names of people on x axis. Now the people on the x axis need to hit a minimum score of say 80%. Is there any way I can show this as a horizontal line on the bar chart?

I have been through the various options in the chart and also checked an excel book but can't find anything.

Any help appreciated.

Bruce T

phendrena
10-23-2008, 09:07 AM
Have a look at this link : http://www.peltiertech.com/Excel/Charts/AddLineHorzSeries.html

Jon Peltier's site is a great resource for charting.

Bruce T
10-24-2008, 02:50 AM
Thank you for pointing me in the right direction

Bruce T

phendrena
10-24-2008, 02:53 AM
My pleasure, always glad to help where i can.

If the link does provide what your looking for then don't forget to mark this thread as solved using the thread tools.