3 votes2 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
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.
An error occurred while saving the commentMark commented
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.