I'm reading up on what I can regarding dynamic dashboards and charts. And while i have got the basics of VBA down, I just can't seem to understand where to start in creating these dynamic charts.
I have attached some sample data that shows Revenues for 6 different departments for 49 different locations. This data is actually pulled from an online source where I need to set what I want to look at via a pivot table. The attached is a copy of that pivot data.
The idea here is to have a drop down or other selections where the user can view a clustered column chart. The user could either chose a specific location or region (which groups X number of locations) and then also be able to view the information either by Year, Quarter or Month/Period.
Note, I can't actually show which locations go to each region. The pivot data i receive doesn't do that way. so its either choose All properties, and then a location. Or chose a region and no actual location.
Ideally, I would love it if possible to show a comparative of this year,quarter, period vs last year, quarter, period. But not sure if the data is currently structured in a way to do that.
I've never been to strong with dynamic charts and learning this part as I go along.
If any has any suggestions, good tutorials, etc as well, I welcome them in trying to learn and create this.
Thanks
PT
Bookmarks