View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] msb2ncsu@gmail.com is offline
external usenet poster
 
Posts: 1
Default Series display order sequential, not grouped side-by-side

I have basic data with a grouping ID for each series:
9.65 1
5.95 1
15.9 1
8.25 1
22.5 2
0.0 2
2.65 3
6.2 3
4.1 3

I want three series (one for each grouping ID) but for each series to
be charted in its entirety before the next series is charted.

Currently the column chart has columns drawn as:
Series1.Value1, Series2.Value1, Series3.Value1, Series1.Value2,
Series2.Value2, Series3.Value2, etc

But I want:
Series1.Value1, Series1.Value2, Series1.Value3, Series1.Value4,
Series2.Value1, Series2.Value2, Series3.Value1, etc.

Series Order only change which series