How to create cascade charts excel 2010

Asked By Lynn Delmerico 30 points N/A Posted on - 04/30/2013

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?

• Status: Open
• Question Views: 1371
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Francis Solari 0 points N/A #150192

How to create cascade charts excel 2010

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

Or you can go check this guide here. 

Hope this helps!

About Francis Solari

Questions
4

Answers
16

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 05/13/2013
• Question Category: MS Excel