I have a set of data that needs to be charted that is changing based on drop down that the user selects.
The data looks like this
Product | Month 1 sales | Month 2 sales ..... | Month 12 sales
product1 30 30 20
The number of products changes drastically (1-40) based on a dropdown on another sheet. I'd like to graph this data automatically using vba or any other trick.