View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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