Creating chart based on user dropdown for x and y axis

Hello,

this can be done without VBA, using range names. Use two range names, one for "myXaxis" and one for "myYaxis". Then build formulas that point the range name to the column selected in the side bar. You may want to use a helper table that shows the number of columns that need to be offset from a starting column (for example offset from column E). You could add a column to the table that you use for the X and Y axis list value. I don't quite know what column is represented with "Changeover Type". You have to help me out here. Also, it is not quite clear what kind of chart you want to create.

In general the approach goes like this:

Create one range "myBase" that points to the data in column E, for example. Then enter the column offset for each of the options into column G on the references sheet. You don't really need two lists if X and Y choices are identical, but just in case they may not remain identical, let's go with the current setup. Create the range names for X and Y with the following formulas:

myXaxis =Offset(myBase,0,vlookup('DATA ENTRY'!$C$21,'REFERENCES - DO NOT TOUCH'!$E$24:$G$32,3,false))
myYaxis =Offset(myBase,0,vlookup('DATA ENTRY'!$C$22,'REFERENCES - DO NOT TOUCH'!$F$24:$G$32,2,false))

Then create a chart, manually select X and Y ranges, then edit the chart and plug in the dynamic range names instead.

What is not quite clear is if you want to plot all populated rows from the Data entry sheet.

Please clarify.