Waterfall Chart or your better idea

Hey guys,

I guess creating a waterfall chart to depict progress on project completion is rocket science, so I am enlisting you help!

See Attached Book2.xlsx

I am trying to create 3 charts. Look at the tables with the red headings first.

I have 298 sites in my project. 203 are complete. 95 are pending complete. I need breakout the 95 sites that are pending complete listed in the breakout table to the right.

All of this is supposed to be in a waterfall chart. Ideas?

Next, See the blue tables.

I have 298 sites, 160 have been submitted. 160 approved by CX. 145 Approved by PA. 142 Customer Submitted. I need to breakout the 142 sites kinda as shown.

138 of the sites have not been submitted yet by the 4 companies as shown.

I just need to create a chart to present this. I don't care if it's waterfall or not.

Hi!

Waterfall chart is just suitable for your goals. Look at this
wc.PNG

or in the file Book2.xlsx

How to create the chart you can find out following the link
http://fincontrollex.com/?page=products&id=1&lang=en

Does anyone have a free idea?

Can we at least agree that this is pretty complicated for someone who has never done this before? I've reviewed the tutorials before coming to this site. I cannot get my data to work.

Sometimes its hard to reverse engineer something when your situation is a bit different! I'll be hanging out here waiting for the great minds to collaborate!

I will give it a whirl and ask you guys for help along the way.