M
Marcus
max num series per chart 255: Any way to go around it?
Excel 2003 Professional
The maximum series per chart is 255(I think).
I have a lot of data that I need to print in a stacked bar chart. The
chart's X-axis represents the time and Y-axis which entity it is. For each
entity there are four different states(4 different colours) that are
scheduled in time. These different states will used many times, in different
order, of each entity.
Example: Entity 1:
State1(3s), State4(10s), State3(7s)State1(8s), State3(6.5s), State4(3.4s)...->
Entity 2, ..., Entity n may have a different order and size of the different
states compared to one another.
When I create this chart I solved it by creating one serie for each State in
time. I will easily exceed the maximum number of series per chart
. By the
way I'm using VBA to create my chart.
Are there any other way to solve this problem? Any way to go around it?
Please help!
/Marcus
Excel 2003 Professional
The maximum series per chart is 255(I think).
I have a lot of data that I need to print in a stacked bar chart. The
chart's X-axis represents the time and Y-axis which entity it is. For each
entity there are four different states(4 different colours) that are
scheduled in time. These different states will used many times, in different
order, of each entity.
Example: Entity 1:
State1(3s), State4(10s), State3(7s)State1(8s), State3(6.5s), State4(3.4s)...->
Entity 2, ..., Entity n may have a different order and size of the different
states compared to one another.
When I create this chart I solved it by creating one serie for each State in
time. I will easily exceed the maximum number of series per chart
. By theway I'm using VBA to create my chart.
Are there any other way to solve this problem? Any way to go around it?
Please help!
/Marcus