Stacked and column chart series overlap

[Thomas Kuriakose]

Respected Sirs,

I have a chart where the data is displayed in a column, stacked and line chart.

I need the data for the month of Jan and Feb to be spaced apart with the same width for the stacked series and for the column series as shown in the right beside the chart.

Now the overlap is in the same plane.

Thank you so much,

with regards,
thomas

 

[Luke M]

Need to get fancy with our charting skills to created a clustered-stacked chart. The key is in how we layout the data. I took your file and shifted the data around as you'll see, so that each row is a separate "stack", but this lets us put purple and green in a stack and the red in a separate stack.

 

[Thomas Kuriakose]

Respected Sir,

This is perfect. Thank you very much for the insight on fancy plotting.

I was struggling to get this work without moving the data.

Thanks once again,

with regards,
thomas