View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
John Krsulic[_2_] John Krsulic[_2_] is offline
external usenet poster
 
Posts: 6
Default Adding a Benchmark line in an Excel chart

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.