Forum home » Delegate support and help forum » Microsoft Excel Training and help » Financial Charts

Financial Charts

ResolvedVersion 2003

Fri 17 Dec 2010, 16:04 Delegate Stuart said...

Stuart has attended:
Excel Advanced course
Excel Advanced course

Financial Charts

Is there a specific add in to create waterfall charts?
I can't seem to find the setup in the standard package?

Fri 17 Dec 2010, 16:26 Trainer Anthony said...

RE: Financial Charts

Hi Stuart, thanks for your query. There is no specific wizard to create a waterfall chart. Instead you create a stacked column chart and remove the fill colour from the first series of columns, thereby giving the illusion that the second series is hanging in space. This link gives you a good walkthrough of the process:

http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips

Financial Charts

Financial Charts

RE: Financial Charts

Excel articles

Excel tip:

Printing spreadsheets without opening them first