Jacob Petersen
New Member
Hi Excel Experts!
I am running Excel 2010.
I have a raw data set consisting of about 31000 rows and 10 columns. In my columns, month, year, product details, volume, sales etc.
I have created a dashboard with 6 different charts connected to separate pivot tables, where the pivot tables are located in separate sheets. The dashboard is created with slicers (8) and the selection will provide the appropriate graphs.
My problem occurs when i clear the selection and choose a specific product area (or simply clear all). One product area contains more than 255 different kinds, and i get the dialog box: maximum number of data series per chart is 255 and it will pop up on my screen multiple times
I have a few suggestions for what could be done, but I cannot figure out how to do it.
I am open to any suggestions, but wanted to give some of my ideas as well.
I really hope someone can help me out, because I have been looking around for a long time for an answer, but have not been able to find one.
Kind regards,
Jacob
I am running Excel 2010.
I have a raw data set consisting of about 31000 rows and 10 columns. In my columns, month, year, product details, volume, sales etc.
I have created a dashboard with 6 different charts connected to separate pivot tables, where the pivot tables are located in separate sheets. The dashboard is created with slicers (8) and the selection will provide the appropriate graphs.
My problem occurs when i clear the selection and choose a specific product area (or simply clear all). One product area contains more than 255 different kinds, and i get the dialog box: maximum number of data series per chart is 255 and it will pop up on my screen multiple times
I have a few suggestions for what could be done, but I cannot figure out how to do it.
- Create a macro that autoclick the dialog box multiple times, so the end user will not see this message (However, it has to work on another computer as well, when I will email it forward
- For example 3 sliders must be selected before it will plot it on the graph. In this way, it will limit the number of products, and be within the 255 chart limit.
I am open to any suggestions, but wanted to give some of my ideas as well.
I really hope someone can help me out, because I have been looking around for a long time for an answer, but have not been able to find one.
Kind regards,
Jacob
Last edited: