Chart with more than 255 series
If you have a lot of data and want to display it graphically, then Excel has a limitation that it does not allow to display more than 255 series or data. The number of data per set is unimportant but you can only display 255 series. So if you have more thant 255 data sets, then the message "The Maximum number of data series per chart is 255" will appear.
The same is if you want to split one column in multiple smaller ones. Go to this link.
So here we are going to show you how to circumvent this :-)
Now suppose you have 300 sets of data and would like to display them this way.
And you want to have this....
Here is how to split this 7 column very long table with more than 300 sets of data into something that you can then display.
If you try to make a table for 300 data sets, you will get the following error "The Maximum number of data series per chart is 255."