Max value in chart

[tiredofit]

Can someone tell me the correct syntax to find the max value on the x-axis of a chart?

For example, if the x-axis consists of dates, such as 1/1/2019, 1/2/2019, ..... , 1/11/2019, 1/12/2019, how can I identify the value 1/12/2019?

Thanks

 

[mole999]

you could get max from the data set then uses that cell value in a text box, i can't visualise what you are actually trying to show

 

[tiredofit]

you could get max from the data set then uses that cell value in a text box, i can't visualise what you are actually trying to show

I have a chart the scrolls when the user clicks the play button.

I want some code to know when to stop scrolling. That occurs when the max value on the x-axis appears.

For example, if my interval is 2 months, it shows 1/1/2019 and 1/2/2019 to start off with.

Then it shows 1/2/2019 and 1/3/2019.
Then 1/3/2019 and 1/4/2019

etc.

I want it to stop the moment 1/1/2/2019 appears on the x-axis.