Home

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
Highlighted
New Contributor

Hi Experts;

 

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

Excel SampleExcel Sample

Regards

Sreejith 

 

5 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!