Adding a Benchmark line in an Excel chart

[John Krsulic]

I have created a great looking Excel chart. I now need to add a benchmark
line to show what parts of my column bars are below or above the benchmarked
data. Is there an easy way to do this and show the number on the line what
the benchmark actually is? I have just been manually drawing a line with the
line tool then using a text box to write in the number. I would love to be
able to tell Excel what the benchmark is and have it draw it on the graph.

 

[Jon Peltier]

Here's an illustrated tutorial of the approach Dave suggests:

http://peltiertech.com/Excel/Charts/AddLineHorzErrBar.html

- Jon