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

  • Thread starter Thread starter msb2ncsu
  • Start date Start date
M

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
 
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
 
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
 
Back
Top