Max value on auto scaled chart axis

[n0gel]

Hello forum. I'm trying to find a way to read the maximum value displayed on an auto scaling chart. It's the primary horizontal axis and it's in currency. I'm thinking some vba code that will paste the maximum value into a cell so I can work with it. The axis is set so values are displayed every $10,000, so the maximum value will always be a multiple of 10,000. Thanks for any help you can offer.

Edit: I'm using Office 2007 on an XP machine

 

[Gerald Higgins]

Can you derive this by looking at the maximum value in your data, and not directly looking at the chart scale ?

For example, if your chart series data is in the range a1:a100....

=roundup(max(a1:a100),-4)

will find the maximum value, and round it UP to the nearest 10,000.

 

[n0gel]

Thanks Gerald, I have put together a formula that guesses what the chart will do. I didn't use the function you suggested but I got there.