Series display order sequential, not grouped side-by-side

[msb2ncsu]

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

 

[Shane Devenshire]

Hi,

Would you mind explaining this again. I don't see three series, I don't see
any grouped data. I don't understand what you mean by the columns are draw as
"Series1.Value1, Series2.Value1, Series3.Value1, Series1.Value2,..."

Thanks,
Shane Devenshire

 

[Andy Pope]

Hi,

If you arrange your data in 3 columns keeping the values in there current
row positions.

9.65 <Empty> <Empty>
5.95 <Empty> <Empty>
15.9 <Empty> <Empty>
8.25 <Empty> <Empty>
<Empty> 22.5 <Empty>
<Empty> 0 <Empty>
<Empty> <Empty> 2.65
<Empty> <Empty> 6.2
<Empty> <Empty> 4.1

Plots as cluster column and then set the Overlay value to 100.
Format Series > Series Options > Overlay

Cheers
Andy