Forum Discussion
Excel Stacked Bar Chart
@When I create a Stacked Bar Chart, chart is not showing any Bars why
4 Replies
With permission from everyone, if I may add to the very good implementation by Mr. Sergei Baklan (@Sergei Baklan).
Here is also a ready-made template from Microsoft itself, which could very well match your version.Is made only with formulas and conditional formatting.Gantt project plannerhttps://templates.office.com/en-us/gantt-project-planner-tm02887601?omkt=en-001
I added the same file that you will find in the link. You can download it directly.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
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.
SergeiBaklan Thank You so much, I have attached a sample file here
Perhaps you mean something like this
- 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
