Button Macro to Recreate Graph With New Y-axis Values

I'm not sure what you mean by "Flip the y-Axis values" I'll assume you mean, reverse the direction, so 1, 2, 3 gets plotted as 3, 2, 1. Format axis -> "Values in reverse order" will do that.

First I added a couple of rows to give you an area to define which data set you want to plot. I set up a data validation of type list with allowable values of 1,2,3,4 in cell B1.

You don't need VBA to do this. Named ranges will do the trick. I highlighted the range H1:KD1 and named it X_Axis.

Then I defined a name Y_Axis as =OFFSET(X_Axis,'Please _HELP'!$B$1,1) this gives the same range as X_Axis, but whatever the value in B1 is rows down.

I assume you want an X-Y plot. So what I did was highlight cells H3:L4 - I could have selected any number of columns, I just wanted to have something to create a chart. With this range, I made the X-Y plot and reversed the Y Axis.

Then I right clicked on the chart and selected Select Data. There is only one series to select. Select it and click on Edit. For the Series X Values Replace ='Please _HELP.xlsb'!$H$3:$L$3 with ='Please _HELP.xlsb'!X_Axis. Do the same kind of thing for the Y_Axis.

Your chart is complete. OK your way out of the setup. Now when you select a number in cell B1, you will get the chart for that line of data.