Forum Discussion
Interactive Dashboard chart from multiple splicers
I have created 3 different charts of the same type from 3 different sets of data. I create them by using pivot table and splicer. How do I transform them into a single dashboard chart but able to show the different chart interactively one at a time. I also intend to add more data sets to this chart .Attached is my workbook .
Liphor Something like in the attached file perhaps? It's just a very rough model, based on your data and done with Power Pivot and would require further refining though. Use the slicers to select the year and region.
9 Replies
Liphor Something like in the attached file perhaps? It's just a very rough model, based on your data and done with Power Pivot and would require further refining though. Use the slicers to select the year and region.
- Your proposed solution looks good, However because I have no knowledge of Power Pivot so I have to spend a couple of days to learn about this function. Where is in located in the excel menu. I am currently using excel 2016 and 2021 on my laptops. I would also like to ask whether I could add additional line like cumulative and mean values in this graph. Thank you for introducing me to power pivot.
Liphor Not sure about 2016, but in 2021 you should see Power Pivot in the top menu as shown in the top right-hand corner of the picture below.
