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

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

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

" wrote:

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

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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
wrote in message
...
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