I want to have to separate stacked columns listed for each quarter of data - Obi Wan you're my only hope!

[08730000000BrGM]

Hello!

Below is my data and the accompanying graph. I've looked across forums (including MrExcel), YouTube, and MSFT help pages and I can't seem to figure out how to separate the stacked column 'ANZ' data from the 'APAC' data. I DO NOT WANT TO HAVE ALL THE DATA STACKED IN THE QUARTER!!!

My goal is to have two stacked columns per quarter:

1. ANZ stacked column (churned and renewed)
2. APAC stacked column (churned and renewed)

Is there a way to do this? Also if you know of a thread that already covers this topic, please provide link. I couldn't seem to find the same question already posed.

Thank you to the Excel Jedi who can solve my problem!!!!!!!!!!!

 

[COwen]

Try using a Column Chart rather than a Bar Chart.

 

[08730000000BrGM]

@sameri

Try using a Column Chart rather than a Bar Chart.

I'm already using a column chart and the bar chart has the same issue, just changes the axis.

 

[COwen]

This is what I get with a Column Chart. Looks a bit messy but that could be fixed with a bit of work.

 

[COwen]

That's your data...

 

[08730000000BrGM]

This is what I get with a Column Chart. Looks a bit messy but that could be fixed with a bit of work.



View attachment 11519

Good idea, but I'm really hoping to stack by region for each quarter.

 

[COwen]

The only thing I can tell you from the information I have, is to play around with several chart configurations...

 

[08730000000BrGM]

Thanks for the help! I'll keep playing around until something works.

 

[COwen]

Sorry I couldn't be of more help.