Excel Stacked Bar Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1766248%22%20slang%3D%22en-US%22%3EExcel%20Stacked%20Bar%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766248%22%20slang%3D%22en-US%22%3E%3CP%3E%40When%20I%20create%20a%20Stacked%20Bar%20Chart%2C%20chart%20is%20not%20showing%20any%20Bars%20why%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766248%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766455%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Stacked%20Bar%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766455%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826978%22%20target%3D%22_blank%22%3E%40Skrish007%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20believe%20you've%20seen%20samples%20of%26nbsp%3B%3CSPAN%3EStacked%20Bar%20Chart%2C%20that%20means%20that%20in%20general%26nbsp%3Bthis%20Excel%20object%20works.%20Why%20it%20doesn't%20work%20in%20you%20case%20-%20that%20could%20be%20tons%20of%20reasons%2C%20e.g.%20you%20selected%20wrong%20range%20as%20data%20source%2C%20or%20you%20have%20texts%20instead%20of%20numbers%2C%20whatever.%20Without%20sample%20file%20it's%20hard%20to%20say%20something%20concrete.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766475%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Stacked%20Bar%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20You%20so%20much%2C%20I%20have%20attached%20a%20sample%20file%20here%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

@When I create a Stacked Bar Chart, chart is not showing any Bars why

4 Replies
Highlighted

@Skrish007 

I believe you've seen samples of Stacked Bar Chart, that means that in general this Excel object works. Why it doesn't work in you case - that could be tons of reasons, e.g. you selected wrong range as data source, or you have texts instead of numbers, whatever. Without sample file it's hard to say something concrete.

Highlighted

@Sergei Baklan Thank You so much, I have attached a sample file here 

Highlighted

@Skrish007 

Perhaps you mean something like this

image.png

- change source data order

- build chart

- set custom values for min/max and units for X-axis

- show y-axis in reverse order

- fill Start Date series by white

Highlighted

@Skrish007 

 

With permission from everyone, if I may add to the very good implementation by Mr. Sergei Baklan (@Sergei Baklan).