Stacked and Clustered bar chart

[Denise]

Is it possible to create a bar chart that has both stacked and clustered data?

The pre-set options appear to be only "either stacked, or clustered".

Thanks in advance.

 

[fairwinds]

Hi,

Create a stacked chart.

Select one of the data series.

Right click, format data series, axis, secondary axis.

then: Options and adjust gap and overlap as you like.

 

[Denise]

It worked - Thanks!

Denise

 

[charlesloves2read]

It worked - Thanks!

Denise

Hi, I tried doing the same but it didnt work. instead of moving together. 1 moved left and the other moved right.