Hi guys,
I've been asked to try and do a waterfall graph using a range of data and it's proving to be a pain to figure out how to do it.
A waterfall graph uses a series of data in a bar chart type format where the bottom of the second bar starts at the finishing point of the first.
For example if the profit (in units) for a company over the year are:
Jan 50
Feb 30
Mar -40
Apr 90
then the bar for Jan ranges from 0-50, Feb from 50-80, Mar from 80-40, Apr from 40-130 and so on. I am pretty sure it can be done in Excel, but I can't get there.
Can anyone help?
Kind regards,
Mooski
I've been asked to try and do a waterfall graph using a range of data and it's proving to be a pain to figure out how to do it.
A waterfall graph uses a series of data in a bar chart type format where the bottom of the second bar starts at the finishing point of the first.
For example if the profit (in units) for a company over the year are:
Jan 50
Feb 30
Mar -40
Apr 90
then the bar for Jan ranges from 0-50, Feb from 50-80, Mar from 80-40, Apr from 40-130 and so on. I am pretty sure it can be done in Excel, but I can't get there.
Can anyone help?
Kind regards,
Mooski