Stacking Columns - Comparing 2 stacked columns by month

[simonriwatson]

Is it possible to show two stacked columns for each y axis? I have tried to use a secondary axis but this gives me an overlapping of the 2 columns, when i need the 2 stacked columns to be side by side.

I am trying to show analysis of revenue and cost for two telephone numbers, side by side for each month. Is there a good way to do this?

 

[Andrew Poulsom]

Welcome to the Board.

Look here:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

 

[simonriwatson]

Perfect - didn't know the correct terminology - this is great. Many thanks.

 

[Jon Peltier]

I have since written a newer and hopefully clearer tutorial for Clustered and Stacked Column and Bar Charts