Referencing an external source to set Chart Axis Scale

[TheScott]

Quick Question: Is their any way to referance another cell as the source for a chart axis scale setting? Like pointing 'Maximum Fixed' to cell 'D7'

AxisOptions.png

Thanks

Scott

[Kaper]

You asked about "any"
Not super_easy - but there is.
You can use event handler for worksheet change event (if D7 is written in. if it is a result of formula - then either worksheet Change for source cells for this formula or Calculate event shall be taken into account.

Sample code to be inserted in your worksheet code (see attachment):

Please Login or Register  to view this content.

[TheScott]

The question was somewhat academic I suppose. I had previously seen code similar to yours that set Max, Min, and Tick but was curious if a method existed without using VBA. I do thank you for your response as it looks as if I will likely go the code route. The problem is, I have a good many charts and was looking for a more direct way of getting it done.

Thank You

Scott