Hello

First Post. Love the forum

I have a data validation list where the user can choose up to 10 items from a drop down. If they only want to choose 2 items, then can as well. A graph is linked to a vlookup which detects what item the user has chosen and graphs the data for the last 5 years.

My problem is that all the 10 items show up on the graph. If someone only enters in two items, there remains 8 blank series on the legend in the graph. Is there a way to only graph the number of items that the user wants and not display all 10 items on the graph?

So if I choose 4 items, only 4 will show up on the graph? Not the remaining 6 items that weren't selected?