-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
waterfall chart
-
L
How to show multiple lines in a waterfall chart?
Hi, I want to create a waterfall chart that shows the accumulative value of rainfall for each year. So basically the line can only go up. The X-axis shows the days from 0 to 366 The Y-axis shows the rainfall value in mm (0 to 1500) I am able to do that for one year but if I want to add a second...- LRATOZ
- Thread
- Replies: 4
- Forum: Excel Questions
-
A
Stacked waterfall graph problems
Hi All, I am trying to adjust a waterfall/bridge graph that is used to analyse operating profit year on year. The graph is illustrating the change in operating profit by Business units. Within one Business unit there has been a £1.5m growth and a £1.7m loss within a new branch unique to...- anilsss
- Thread
- Replies: 0
- Forum: Excel Questions
-
P
Overlapping Waterfall Chart
I have a waterfall chart (for no reason other than I thought it would be different) with costs up one side for various dates along the other. This works, I've got this bit sorted, pretty confident at the selecting of cells. What I want to have is another set of data that isn't the same size...- PostTIT
- Thread
- Replies: 0
- Forum: Excel Questions
-
K
Adding a Segmented Bar to a Waterfall Chart
Hi, I have two charts. The first one is a waterfall chart with bars for for sales opportunities and their stages of completion.i.e the x-axis will have the % to completion at which the deal currently stands at such as 90%, 70% etc. and the y-axis refers to the amount of the deal. The second...- kevinm87
- Thread
- Replies: 1
- Forum: Excel Questions
-
B
Dynamic Watefall chart
Hi, Is there a way of making the formatting of a graph so that the start and End bar are always the same colour format? I think this is probably VBA but a VBA trick but no sure? The reason i need to do this is I am using dynamic waterfall chart (using a stacked graph) where the X axis changes...- Branagan_1
- Thread
- Replies: 0
- Forum: Excel Questions
-
L
waterfall chart scale
I'm working on implementing a waterfall chart into some month end cash flows charts and am having trouble with the scale. I have an inflow that is infinitely bigger than all the other inflows and am wondering how to "hide" a portion of the graph so all the inflows show up on the graph. Just...- lhumble
- Thread
- Replies: 3
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
loop through merged cells in a Column to get their addresses
- Replies: 46
I have one column. say column A, which has multiple merged cells of different ranges. for example first cell is merged from A2 to A15 whereas... -
Split a Column into 2, use a character limit that does not cut words in half.
- Replies: 31
Title says it all. I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The... -
change colour of picture based on cell value
- Replies: 44
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
Preventing duplicates
- Replies: 24
Hi everyone, I am using a userform to add data to my worksheet, my userform uses a combobox to to show the list that exsists but also allows for... -
EXCEL SHEET auto enter Dates
- Replies: 23
Hi All , I am came to this forum after a long time , this is the great platform and with awesome people , where stranger of no where will help... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...