ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   waterfall graph with negative values (https://www.excelbanter.com/charts-charting-excel/189726-waterfall-graph-negative-values.html)

Lucas

waterfall graph with negative values
 
Can anybody be so kind as to help me with creating waterfall (cascaded) graph
because I spent 1h and I give up.

I'd like to have 3 bars:

1) One starts at 0 and decreases by 5 (i.e. ends at -5).

2) Starts at -5 and increases by 10 (i.e. ends at +5).

3) Starts at +5 and decreases by 5 (i.e. ends at 0).

Many thanks in advance for help!
lucas

Andy Pope

waterfall graph with negative values
 
Hi,

Have you seen Jon's page on waterfall charts?
http://peltiertech.com/Excel/Charts/...lcrossing.html

Cheers
Andy

lucas wrote:
Can anybody be so kind as to help me with creating waterfall (cascaded) graph
because I spent 1h and I give up.

I'd like to have 3 bars:

1) One starts at 0 and decreases by 5 (i.e. ends at -5).

2) Starts at -5 and increases by 10 (i.e. ends at +5).

3) Starts at +5 and decreases by 5 (i.e. ends at 0).

Many thanks in advance for help!
lucas


--

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

Lucas

waterfall graph with negative values
 
thanks Andy!

"Andy Pope" wrote:

Hi,

Have you seen Jon's page on waterfall charts?
http://peltiertech.com/Excel/Charts/...lcrossing.html

Cheers
Andy

lucas wrote:
Can anybody be so kind as to help me with creating waterfall (cascaded) graph
because I spent 1h and I give up.

I'd like to have 3 bars:

1) One starts at 0 and decreases by 5 (i.e. ends at -5).

2) Starts at -5 and increases by 10 (i.e. ends at +5).

3) Starts at +5 and decreases by 5 (i.e. ends at 0).

Many thanks in advance for help!
lucas


--

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



All times are GMT +1. The time now is 06:08 AM.

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