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.
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.
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."