Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
reference line on bar chart
Hello,
I have excel 2007 I have a horizontal bar chart with about 12 bars. The horizontal axis shows the date; dates range from about 10 days ago to about 3 weeks into the future. I want to draw a vertical reference line at Today's date. Can anyone tell me how to do it please ? Thanks KK |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
reference line on bar chart
Start here
http://peltiertech.com/Excel/Charts/...orzErrBar.html If that is not good for you, I am sure Jon has an answer that will work for you best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "KRK" wrote in message ... Hello, I have excel 2007 I have a horizontal bar chart with about 12 bars. The horizontal axis shows the date; dates range from about 10 days ago to about 3 weeks into the future. I want to draw a vertical reference line at Today's date. Can anyone tell me how to do it please ? Thanks KK |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
reference line on bar chart
Hi,
There are examples of bar and vertical datum line here. http://www.andypope.info/charts/averageline.htm Cheers Andy KRK wrote: Hello, I have excel 2007 I have a horizontal bar chart with about 12 bars. The horizontal axis shows the date; dates range from about 10 days ago to about 3 weeks into the future. I want to draw a vertical reference line at Today's date. Can anyone tell me how to do it please ? Thanks KK -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Chart Type - Line Column adding a 2nd line | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |