Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel
Resolved · High Priority · Version 2003
Reply Fri 18 Jul 2008, 16:37Delegate Yunyun said...
Yunyun has attended:
Powerpoint Intermediate Advanced course
Excel
how to create a waterfall chart in Excel?
For upcoming training course dates see: Pricing & availability
RE: Excel
Hi Yunyun,
Thank you for your question, welcome to the forum, in answer to your post;
As I'm sure you know Excel does not have a waterfall chart option, however there are proprietry programs that can be purchased as a bolt on.
If however you want to do a little bit of "cheating" you can follow these steps, I apologise for the data and cell references just being referred to and expecting you to have the same: so you might have to create a little table of your own first to follow the steps, and data as long as it is relevant will do;
So follow these steps to create this type of chart:
1. Use the Chart Wizard to create a stacked bar chart from a range eg A2:C13.
2. In Step 2 of the Chart Wizard, select the Columns option. Notice that Excel incorrectly uses the first two columns as the Category axis labels.
3. Also in Step 2 of the Chart Wizard, click the Series tab and add a new data series. Then set the chart
|