I have a chart ('Microsoft Graph Chart') on my form. I want users to be able to change the scaling of the X and Y1 and Y2 axes of the chart. They can do this by:
clicking on the chart
double clicking again on the chart
double clicking on the axis to select an axis
righlt clicking and choose Edit Axis
and then they finally get to the "Format Axis" dialog
This is tedious and not obvious. Is there a way to pop up this Format Axis dialog for any axis by using my own command button? I know how to change the scale with VBA and reset it but I want that pop up dialog for the user so they can do interactively.