I am a statistician and I would like to create a cascade chart that would create and show all bars bridge from one end to the other. However, I have a negative value for my equations and I am wondering if it will show on the cascade chart excel that I am currently using. I use the 2010 version of excel cascade chart. Would it be possible to have the bars still bridged from one end to another with the negative values for my data?
Based on your summary question you want to know how to make cascade charts, but after reading your questions in details, seems like you already know how to make cascade charts and is just concerned about the negative values so here you go:
Your first question is if negative values will show up in the chart.
Yes it will show up.
Your other question is if it’s possible to have the bars bridged with the negative value.
Yes that is also possible, as you can see in the examples below, the negative values are showing up but the bars are still connected from one end to the other.
If you want the step by step guide, you can also watch this video below