How to make value on Horizontal line change

M

Meenie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

question on horizontal line on chart 0
How to make the shading look uniform around a double spaced line in MS Word? 0
Avoiding cells being included in a chart 4
Labeling on independently stacked line chart 0
Show average value as a horizontal line in a column chart 4
Macro to change position of chart labels on line chart 1
Show average line by series on a line chart 1
Dividing a chart with a horizontal line 2

Top