Zum Hauptinhalt wechseln

Waterfall Chart

Garden City Consultants

2.0 (4)

A tool to visualize the cumulatie data into positive, negative and total bar chart

Description:

Waterfall Chart Add-in is a tool in Excel to visualize the cumulative data series in up, down and total bar chart that is mostly used for visualizing financial statement data.

In the setting window, user can use the Color Picker button to select the colors for up, down, and total bar.

The total item is calculated automatically. The total item label can be set in the setting window. The default value is set for the sample data.

The font size of the bar label can be set in the setting window. Default is set to 8px.

Features:

  • Customizable colors and mapping values.

  • Easy to use and user-friendly are the key features of this add-in. Sample data can be the template to build own data.

  • Interactive Chart: the chart is binding to the data table in the sheet, when you update the data, you can see the chart updating.

Instruction:

  • Download this add in and start Excel 2013 SP1 and later.

  • Click Insert Sample Data button to insert data and draw the chart.

  • Update the data with own data.

  • Change the caption of the "Total" item in the Setting window.

  • In the setting window, select the bar color as preferred.
Add-In-Funktionen
Hinweise für die Verwendung dieses Add-Ins:
  • Es kann Ihr Dokument lesen und Änderungen vornehmen.
  • Es kann Daten über das Internet senden.
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680782/Asset_996bd0e5-45cc-4ea1-ada5-fe9ebf8038d4/WaterfallChart1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680782/Asset_996bd0e5-45cc-4ea1-ada5-fe9ebf8038d4/WaterfallChart1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680782/Asset_9b4a6d77-5c83-46c4-b3f6-dc9ed6506e27/WaterfallChart2.png