Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Yunyun has attended:
PowerPoint Intermediate Advanced course

Excel

how to create a waterfall chart in Excel?

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

PowerPoint tip:

Another way to reduce PowerPoint file sizes

A very quick and easy way to reduce the size of a PowerPoint file (particularly if it contains many images and/or objects) make the first slide in the presentation a blank slide (using slide layouts).

Why does this work? Because when you go to open the file through PowerPoint (File - Open or by using the Open button), the preview image that PowerPoint sees of that file is of a blank slide so the overall file size is reduced.

View all PowerPoint hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.