Preparing a stacked chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1177374%22%20slang%3D%22en-US%22%3EPreparing%20a%20stacked%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177374%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20in%20preparing%20the%20stacked%20chart%20as%20in%20the%20image%20below%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20Sample.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171474iE8464B6292A73C7D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Excel%20Sample.jpg%22%20alt%3D%22Excel%20Sample%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EExcel%20Sample%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ESreejith%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1177374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177511%22%20slang%3D%22en-US%22%3ERe%3A%20Preparing%20a%20stacked%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177511%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F560175%22%20target%3D%22_blank%22%3E%40EuroSree%3C%2FA%3E%26nbsp%3BTry%20the%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177516%22%20slang%3D%22en-US%22%3ERe%3A%20Preparing%20a%20stacked%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177516%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F560175%22%20target%3D%22_blank%22%3E%40EuroSree%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20suggestion%20would%20be%20to%20transform%20the%20data%20to%20look%20as%20follows%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PReagan_0-1581948700981.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171483i433C9ABB43BF608C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22PReagan_0-1581948700981.png%22%20alt%3D%22PReagan_0-1581948700981.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOnce%20you%20transform%20your%20data%2C%20review%20the%20following%20Clustered%20Stacked%20Bar%20Chart%20video%20on%20YouTube.%20Review%20also%20the%20attached%20workbook.%20Please%20let%20me%20know%20if%20you%20have%20any%20further%20questions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178614%22%20slang%3D%22en-US%22%3ERe%3A%20Preparing%20a%20stacked%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178614%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178619%22%20slang%3D%22en-US%22%3ERe%3A%20Preparing%20a%20stacked%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178619%22%20slang%3D%22en-US%22%3EI%20had%20seen%20the%20videos%20but%20the%20arrangement%20of%20the%20data%20was%20the%20problem.%3CBR%20%2F%3EThank%20you%20so%20much%20for%20working%20out%20the%20option%20for%20me%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1180660%22%20slang%3D%22en-US%22%3ERe%3A%20Preparing%20a%20stacked%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1180660%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F560175%22%20target%3D%22_blank%22%3E%40EuroSree%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20pleasure!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446243%22%20slang%3D%22en-US%22%3ERe%3A%20Preparing%20a%20stacked%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446243%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20something%20similar.%20I%20have%20the%20following%20example%20where%20from%20Company%201%20and%202%20i%20have%20one%20price%20given%20for%20a%20product%20where%20from%20company%203%20i%20have%20a%20range%20of%20prices%20for%20each%20product.%20How%20can%20i%20present%20it%20in%20one%20bar%20chart%20for%20presentation%3F%20(a%20mix%20of%20normal%20price%20and%20a%20bar%20showing%20a%20range%20in%20the%20same%20chart%3D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22313%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2268%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2272%22%3ECompany%201%3C%2FTD%3E%3CTD%20width%3D%2272%22%3ECompany%202%3C%2FTD%3E%3CTD%20width%3D%22101%22%3ECompany%203%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EProduct%201%3C%2FTD%3E%3CTD%3E100000%3C%2FTD%3E%3CTD%3E150000%3C%2FTD%3E%3CTD%3E110000-130000%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EProduct%202%3C%2FTD%3E%3CTD%3E500000%3C%2FTD%3E%3CTD%3E250000%3C%2FTD%3E%3CTD%3E230000-260000%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Eproduct%203%3C%2FTD%3E%3CTD%3E150000%3C%2FTD%3E%3CTD%3E100000%3C%2FTD%3E%3CTD%3E90000-120000%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi Experts;

 

Please help me in preparing the stacked chart as in the image below

Excel SampleExcel Sample

Regards

Sreejith 

 

6 Replies
Highlighted

@EuroSree Try the attached.

Highlighted

Hello @EuroSree,

 

First suggestion would be to transform the data to look as follows:

PReagan_0-1581948700981.png

Once you transform your data, review the following Clustered Stacked Bar Chart video on YouTube. Review also the attached workbook. Please let me know if you have any further questions.

 

Highlighted
Thank you so much
Highlighted
I had seen the videos but the arrangement of the data was the problem.
Thank you so much for working out the option for me
Highlighted

@EuroSree 

 

My pleasure!

Highlighted

Hello @PReagan 

 

i want something similar. I have the following example where from Company 1 and 2 i have one price given for a product where from company 3 i have a range of prices for each product. How can i present it in one bar chart for presentation? (a mix of normal price and a bar showing a range in the same chart=

 

 Company 1Company 2Company 3
Product 1100000150000110000-130000
Product 2500000250000230000-260000
product 315000010000090000-120000