Hi -
I have a chart with two axis. Thew primary axis is of no importance to this question.
The secondary axis charts one of four options, defined by a checkbox (form control). A simple formula chooses the data range based on the true or false output of the checkboxes.
Now I would like to over ride the automatic scale for one of the selections. For arguements sake - Option2.
When option 2 is selected from the checkbox, I would like it to use a predefined scale on the secondary axis, instead of the default settings.
Can anyone advise on the possibility of this? I am happy to change the form controls to VBA, however my VBA knowledge is relatively limited. Could I perhaps activate a macro when the linked cell for option 2 is TRUE, which would re-define the scale bar for that particular option, and then revert back to default automatic scale once the linked cell reads false?
Many thanks for any input!
P.s, This is a new account, my previous one seems to be misbehaving!
I have a chart with two axis. Thew primary axis is of no importance to this question.
The secondary axis charts one of four options, defined by a checkbox (form control). A simple formula chooses the data range based on the true or false output of the checkboxes.
Now I would like to over ride the automatic scale for one of the selections. For arguements sake - Option2.
When option 2 is selected from the checkbox, I would like it to use a predefined scale on the secondary axis, instead of the default settings.
Can anyone advise on the possibility of this? I am happy to change the form controls to VBA, however my VBA knowledge is relatively limited. Could I perhaps activate a macro when the linked cell for option 2 is TRUE, which would re-define the scale bar for that particular option, and then revert back to default automatic scale once the linked cell reads false?
Many thanks for any input!
P.s, This is a new account, my previous one seems to be misbehaving!
