Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
question on horizontal line on chart
Excel 2003 :)
Ok, I'm able to put a horozontal line on my chart but now I'm trying to make it change... I have a chart (standard clustered column)that shows YTD values from several sources with a horizontal line showing the average of them all. (instructions for adding line from peltiertech.com - thanks Jon!) Here's my problem. These are year to date numbers so they change monthly and so does the average. In the x,y range in my worksheet for the horizontal line, I tried linking the number to the average, and it appears to work - the numbers for 0 and 1 change when the average changes... but the value doesn't change on my chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a vertical line to a horizontal bar chart? | Charts and Charting in Excel | |||
Dividing a chart with a horizontal line | Charts and Charting in Excel | |||
Add horizontal line to a chart | Charts and Charting in Excel | |||
Add line to horizontal bar chart | Charts and Charting in Excel | |||
Horizontal Line Chart | Charts and Charting in Excel |