I have a created a report that has in total 3 seprate charts
1 line; 1 area and 1 3D area graph.

All 3 charts are based on a single range of data in the same sheet.


I have now been asked to include a variation in the number of columns of data that can be selected.
For instance there was originally 10 columns of numerical values to populate the graphs.

Now i need to have a value list on another sheet when selected, vary the amount of columns of data is required to populate the graphs.
It could range from 7 columns to 20 columns of data.
Here is my dilema:

What is the best way to handle this scenario?

Place the data on a separate sheet from the grpahs, or same sheet ?
Hide/Unhide the unused columns ?
Use a filter somehow on the columns of data dependant upon the value list selection ?
How do i handle the options of data required to populate the graphs ?