Home

Creating a Stacked Column Chart with 2 Ranges on same column

%3CLINGO-SUB%20id%3D%22lingo-sub-183553%22%20slang%3D%22en-US%22%3ECreating%20a%20Stacked%20Column%20Chart%20with%202%20Ranges%20on%20same%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183553%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20following%20data%3A%3C%2FP%3E%3CP%3E-%20Months%20over%20a%20year%20(e.g.%20Jan%202017%2C%20Feb%202017%2C%20Mar%202017%2C%20etc)%3C%2FP%3E%3CP%3E-%20Categories%20of%20food%20(e.g.%20sugar%2C%20cookies%2C%20flour%2C%20etc)%3C%2FP%3E%3CP%3E-%20Revenue%20from%20selling%20each%20category%20per%20month%3C%2FP%3E%3CP%3E-%20No.%20of%20transactions%20per%20category%20per%20month%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20make%20a%20stacked%20column%20chart%20with%20two%20axis%20where%20the%20x-axis%20shows%20the%20months%20over%20a%20year%20and%20the%20two%20y-axis%20are%20no.%20of%20transactions%20and%20revenue%20from%20selling%20categories.%20The%20stacked%20columns%20should%20be%20split%20into%20the%20different%20categories.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20I%20am%20having%20is%20that%20I%20need%20the%20revenue%20and%20no.%20of%20transactions%20to%20be%20shown%20on%20the%20same%20stacked%20column%20per%20month%2C%20just%20corresponding%20to%20the%20different%20y%20axis.%20Is%20it%20possible%20to%20do%20this%20on%20excel%20and%20how%20do%20I%20go%20about%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-183553%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Estacked%20charts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291712%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20Stacked%20Column%20Chart%20with%202%20Ranges%20on%20same%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291712%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20ever%20get%20an%20answer%20to%20this%3F%20I%20have%20a%20similar%2C%20possibly%20identical%20problem%3A%20we%20can't%20be%20the%20ONLY%20ones.%20Somebody%20must%20have%20figured%20this%20out%20--%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743980%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20Stacked%20Column%20Chart%20with%202%20Ranges%20on%20same%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743980%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F114995%22%20target%3D%22_blank%22%3E%40Judy%20Tran%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F246684%22%20target%3D%22_blank%22%3E%40Me4one%3C%2FA%3E%26nbsp%3BTo%20create%20a%20stacked%20column%20graph%20where%20each%20segment%20has%20its%20own%20baseline%2C%20you%20need%20to%20add%20invisible%20spacer%20segments%20between%20the%20visible%20segments%20so%20that%20the%20visible%20segments%20line%20up.%20I've%20attached%20a%20file%20that%20gives%20you%20an%20example%20of%20this%20type%20of%20graph%20and%20you%20can%20investigate%20how%20it%20is%20constructed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Judy Tran
New Contributor

Hi,

 

I have the following data:

- Months over a year (e.g. Jan 2017, Feb 2017, Mar 2017, etc)

- Categories of food (e.g. sugar, cookies, flour, etc)

- Revenue from selling each category per month

- No. of transactions per category per month

 

I'd like to make a stacked column chart with two axis where the x-axis shows the months over a year and the two y-axis are no. of transactions and revenue from selling categories. The stacked columns should be split into the different categories.

 

The issue I am having is that I need the revenue and no. of transactions to be shown on the same stacked column per month, just corresponding to the different y axis. Is it possible to do this on excel and how do I go about this?

 

2 Replies

Did you ever get an answer to this? I have a similar, possibly identical problem: we can't be the ONLY ones. Somebody must have figured this out -- help?

@Judy Tran @Me4one To create a stacked column graph where each segment has its own baseline, you need to add invisible spacer segments between the visible segments so that the visible segments line up. I've attached a file that gives you an example of this type of graph and you can investigate how it is constructed.

 

Hope that helps.