VBA to to set Axis values based on cell values

[elliotencore]

Hi All,

I'm trying to set the Maximum Scale and Major Unit of a graph based on cell value.

I've found the following page with some code:

http://peltiertech.com/Excel/Charts/...nkToSheet.html

However I can't get my code to work - here is what I have:

Please Login or Register  to view this content.

Hope somebody can help!

P.S. - Yes, my chart is called "Chart 4"

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[elliotencore]

I added the code to a combobox change event:

Please Login or Register  to view this content.