sanjangeorge
asked on
Excel VBA Dynamic Charting.
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.
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.
Attached are some ideas for dynamic charts, including pivot chart, or charting by row or by column, as per user selection.
If your data source changes "drastically" please provide a few samples of how this could look, so the dynamic formulas can be adusted accordingly.
cheers, teylyn
Book1.xlsx
If your data source changes "drastically" please provide a few samples of how this could look, so the dynamic formulas can be adusted accordingly.
cheers, teylyn
Book1.xlsx
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
can you provide a data sample in an Excel file and explain exactly what you want to chart? There are many ways to skin this cat.
cheers, teylyn