Advertisement

09.25.2008 at 06:45AM PDT, ID: 23762375 | Points: 250
[x]
Attachment Details

How to create a waterfall chart in excel

Asked by PETER9675 in Microsoft Excel Spreadsheet Software, Microsoft Applications

Tags:

I have attched a file that shows the chart in its current stage. I want to simplify the data entry so that the chart uses data from tab called "Data_SAIFI" to create this same chart.

To explain a little further I am trying to create a chart in excel that has the regular bar chart of a certain data, "2006 Month", "2007 Month", "2008 Month Actual Target". Within the same chart I want the amount of "2008 Month Actual" to have a subset, as a waterfall (see file attached) percentage for each piece of "2008 Month Actual".

Let me know if somebody has any ideas.

thanks

Peter N
Start Free Trial
Attachments:
 
Operations-Metrics.xls (219 KB) (File Type Details) 
Waterfall excel Chart file
 
 
Keywords: How to create a waterfall chart in excel
Title
1 Create bar chart
2 Excel - Chart Add-in
3 adding total nubers of respondants an…
4 Excel - Bar Charts
5 Gantt Chart in Excel
6 Excel Chart Column Color Properties
 
Loading Advertisement...
 
[+][-]09.26.2008 at 02:29PM PDT, ID: 22584005

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.28.2008 at 11:13PM PST, ID: 23058882

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628