Waterfall Chart Studio

Waterfall Chart Studio is an advanced Microsoft Excel add-in developed in order to provide data analysts with a quick and efficient means of generating visual charts from their spreadsheets.

While the extension itself can be quite handy, it does require some previous preparation of your data, as it needs to be arranged in a specific format, featuring all the fields for the chart to be generated. Data interpretation can be performed both vertically and horizontally, on condition that it observes the necessary layout.

Waterfall Chart Studio integrates into your Excel ribbon and allows you to quickly access it from the corresponding tab. When you have organized your data in the required layout, that contains the 'Values', 'Labels', 'Title' and 'Range of Series', you can then select the 'Values' column or row, depending on the orientation of your spreadsheet and press the 'Create Chart' button.

Waterfall Chart Studio will display a window enabling you to manually choose the corresponding data columns / rows. After inputting all the required information, you can press the 'OK' button and the extension will automatically generate the Waterfall Chart, presenting dull numbers and calculations in a visually appealing form.

Moreover, Waterfall Chart Studio allows you to customize the chart's design, layout and format. You can change the 'Chart Type' as horizontal or vertical, you can choose what information to include or exclude, change fonts, titles, colors and several others.

The charts generated by Waterfall Chart Studio are dynamic in nature; this means that any data alterations performed in the Excel spreadsheet will be replicated in your chart, recalculating and updating it to display the new values.

To summarize, Waterfall Chart Studio can prove very useful, particularly if you work with large amounts of data on a regular basis and need to create corresponding charts, as it partially automates your tasks, offering the results in a more easily readable form.