Increase number of series from 255 to atleast 1000
For technical or scientific data (eg band structures) we need many data series charted before narrowing down to fewer. The series limit is very annoying and has no fix except to go to open source or a different app.
Could you provide some additional examples or use cases where you need more than 255 series? We want to better understand the scenarios of usage.
I too would like to see the number of points in a series increased or the ability to create the type of chart described below.
Please find attached two sample charts. These two charts provide a very quick and visual way to display when a state or mode change occurs and how long it lasts. The X-Axis has a time scale (either DateTime, hours, minutes). It would be great to have a color legend for each of the states / modes. (Alternatively, I have also created a step chart to display this information, however the State / Mode Bar chart is much preferred by customers).
The two charts are linked to the attached sheet called ModeBarChtData. After a bit of creative work, it was possible to generate these two charts using the Stacked Bar chart type, however I had to put the data into the Legend series which has a limit of 256 items. (To see the underlying data and what I am referring to, right click on the chart then click on Select Data). If I have more than 256 data points the chart will not display them.
Please advise if there is a better way of doing this so that I can display more than 256 states (modes), either by using other chart types or arranging the data in a different manner. If it is not possible to increase the number of points in a series, then perhaps adding a new chart type would be helpful.
In terms of functionality, it would be great to “zoom” this chart along the X axis by simply changing the selected range.
This chart could be used to display other types of information (below are some examples):
1. Time and duration spend sleeping, working travelling, at home.
2. On and Off Ice time.
3. Machine Uptime, Failure time, and Break time, unscheduled time.
4. The list goes on . . .
Please confirm by email that this post has been reviewed, regardless of the decision made. Thanks.
James tanley commented
This is my need also, thanks -- I was going to suggest at least 4096 elements. My charts show the path of a robot, including spots where it has scanned the walls around it and the points it has seen that represent the walls. This leads to a lot of data; more if I use macros to synthesize line segments (with linear regression) from the points it has seen. At this point I need to make several charts for a single run of the robot (the chart runs out of space after about a minute's worth of data) -- it would be great to have all the data on a single chart.
On the other hand, Excel is a terrific product -- I'd never be able to do the display and analysis I can without it; the chart combined with VBA is a great tool.