LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a control line to excel chart without showing up in the leg TWeaver Charts and Charting in Excel 4 September 18th 07 11:00 PM
how to add a horizontal benchmark value line in a column chart? Mike Chro Charts and Charting in Excel 1 July 5th 07 11:26 AM
Adding a line to the line/column chart? Steven Charts and Charting in Excel 2 February 12th 07 09:46 PM
Chart Type - Line Column adding a 2nd line [email protected] Charts and Charting in Excel 1 October 24th 06 04:17 PM
Changing a line color when it crosses another benchmark line? JB12 Charts and Charting in Excel 3 December 10th 05 04:48 PM


All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"