Rather than a command button, could you use an option group with the default axis already selected? Your existing macro (to create the chart) could then pickup the desired axis from the option selected, rather than the user having to run a separate macro to change the axis.