Create chart

[Villalobos]

Hello,

I would like to ask some help to create a chart based on the given data (you can see in the sample file). To represent the desired result I just colored the background of the cells.

Thank you in advance the reply!

 

[Luke M]

Hi Villalobos,

I'm about to head out for the day, but what you're looking for is a waterfall chart. Here's a quick tutorial to get you started:
http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/
which should help illustrate the concepts at least.

 

[Hui]

see attached file:

 

[Hui]

Here's an updated version:

 

[Villalobos]

Hello Hui,

Thank you the help!