VBA code for choosing which column to use as X axis in a plot

[rathalex]

Hello,

I am working on creating an if statement that will allow to a user to choose which column to use (from 3 choices) as X axis while making a plot. Y axis will remain the same. Once user makes the choice, excel should select specified XY range based on choice.Is this possible to create? Please help me with this! Thank You Very Much!

 

[pbornemeier]

Used named ranges for each X data set and the Y data set.
Use an Inputbox to offer the choice.
When the user enters a valid choice, assign the appropriate named range to the chart Values and XValues.

 

[rathalex]

Thank you!