Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to make value on Horizontal line change
I learned how to place a horizontal line on my chart at www.peltiertech.com
(thanks Jon!) but how do I make the value change? I want it to show the YTD average so it changes monthly. I tried linking the two cells that list the value to the cell where the average is calculated, and it changes in the cells but not on the chart. 0 95% <---- 1 95% <---- these two cells (with 95% linked to cell where the average is calculated, and it changes in these two cells, but doesn't change on the chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you make a line of a chart change color halfway through? | Charts and Charting in Excel | |||
Horizontal Line | Excel Discussion (Misc queries) | |||
Graph A Horizontal 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) | |||
Horizontal Line Chart | Charts and Charting in Excel |