ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Bar Charts (https://www.excelbanter.com/excel-discussion-misc-queries/36011-bar-charts.html)

Kirsten

Bar Charts
 
I have a bar chart that has all the information on it I need. I need to take
the information and build it on top of each other (i.e. 10 is the first value
and the second...need to show the first to 10 and the second from 10-20).
But, the last bar can't be a part of the build. The last value is the total
of them all. Is there a way to do this?

Andy Pope

Sounds like you are describing a waterfall chart.

Here are some resources.
http://peltiertech.com/Excel/Charts/Waterfall.html
http://tushar-mehta.com/excel/charts...fall/index.htm
http://edferrero.m6.net/Charting.aspx

Cheers
Andy

Kirsten wrote:
I have a bar chart that has all the information on it I need. I need to take
the information and build it on top of each other (i.e. 10 is the first value
and the second...need to show the first to 10 and the second from 10-20).
But, the last bar can't be a part of the build. The last value is the total
of them all. Is there a way to do this?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com