ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to make value on Horizontal line change (https://www.excelbanter.com/charts-charting-excel/228867-how-make-value-horizontal-line-change.html)

Meenie

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.



All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com