Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charts won't update | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
Working with Charts | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel |