Partially Stacked Pivot Chart: Help

[SAMUSER]

Hi,

I have tried multiple times, but for the life of me, I can't get the pivot chart to stack partially. Essentially, I have three sums in sigma field. I want to stack two of them together, and have one separately to show the comparsion.

Basically, I can stack all three columns in the chart, or unstack all three of them. Is there a way to stack two together, to compare against the third column?

 

[Robert Mika]

Hi,

I have tried multiple times, but for the life of me, I can't get the pivot chart to stack partially. Essentially, I have three sums in sigma field. I want to stack two of them together, and have one separately to show the comparsion.

Basically, I can stack all three columns in the chart, or unstack all three of them. Is there a way to stack two together, to compare against the third column?

One of my fever charts:
AJP Excel Information - Stacked clustered chart
Just make your layout as desrcribed by Andy.