Formula or macro to insert maximum value of a chart axis to a spreadsheet cell

[Dbroek]

I need the maximum value of 700 on the attached chart axis to be automatically entered into the E3 cell. Is there a way to do that via an excel formula or VBA?

On the attached chart, I would like to be able to click on the check box in cell D4 to enable cell C4 to have same max value of 700.

[dangelor]

Possibly with...

Please Login or Register  to view this content.

[Dbroek]

Dangelor,

Thanks, that does work. However, I was hoping that the E3 cell would always be filled with the latest maximum value. In other words, that it would be updated anytime the chart itself is updated.

Sorry, I wasn't clear on the first post on this.

[dangelor]

Try it in the worksheet's code module. Should work as soon a you click on any cell after changing the chart's value.

Please Login or Register  to view this content.

[Dbroek]

Yes. This code does work when I click on another cell after having TRUE be entered in the E3 cell.

However, an unfortunate event occurs every time a chart value is changed or another cell is clicked on. The vertical axis expands another notch and the line graph flattens out. And the secondary chart does not match the Max axis value seen on the chart itself.

[Dbroek]

Just to be clear, I'd like the E3 cell to always have the latest maximum vertical axis value in it. On this attached graph, I also had wanted the value in the C4 cell to match the Max vertical value on the chart itself. Also, I noticed that the E3 cell has a lower value than the max value shown on the chart. Not sure why that is like that...

[dangelor]

Interesting... if you remove the formula in C4 it works as it should. What is the purpose of that formula?

[Dbroek]

I'm just looking for a way for the chart to continue auto adjusting properly regardless of how high a value in the C column is.

[Dbroek]

Hxxxxxx ssss

[Dbroek]

I consider this post solved since my original request was for the max value to be placed inside an excel cell.
dangelor, thank you much for your input.

[dangelor]

Sorry I wasn't much help, though I'd be curious to know why that happened.

[Dbroek]

Sorry I wasn't much help, though I'd be curious to know why that happened.

Not a problem at all. Seems that the chart doesn’t like having a Secondary axis to have the same value as its max value on the chart.

No big deal, I’m just fine with it as it is. Was just wondering if it would work.