This makes it easier for you to modify the data, by inserting or removing table rows. When the rotated waterfall chart is created on a new worksheet, the data and calculations are placed in an Excel Table.

The new “First Bar” setting and updated “Labels” settings are highlighted in the new Rotated Waterfall Chart dialog: Rotated Waterfall Charts have been enhanced in the same way as regular Waterfall Charts. The Waterfall Chart changes apply to both the Standard and Advanced Editions of Peltier Tech Charts for Excel 3.0. The new option is that you can apply positive labels above the bars and negative labels below the bars:įinally, you can hide the labels altogether: You may also place the labels above the bars: If you do not choose this option, the first bar is treated like an other changing value, and it has the color of an up br or a down bar (green or red in this default chart):Īs before, you can choose to center the value labels on the bars: If you choose the First Bar is Subtotal option, the first bar of the data set is treated like any other total or subtotal in the chart, and it has the color used for the full height bars (blue in this default chart): Regardless of the output location of the chart, the two new chart features are available from the dialog and also using the checkbox or listbox next to the output range. I hope to have these available in a few months. Placing the output into a Table will also make it easier for me to build versions of Peltier Tech Charts for PowerPoint and Word. When the waterfall chart is created on a new worksheet, the data and calculations are placed in an Excel Table. If you create the chart on the active sheet, the data still must be in adjacent columns. For example, you could select category labels in the range A4:A12 and values in the range C4:C12. When selecting data, if you choose to output the chart on a new worksheet, you are allowed to use non-contiguous data ranges. The Waterfall Chart dialog has been changes, with a new “First Bar” setting and updated “Value Labels” settings. There are no new chart types in this update, but there are major enhancements to some existing charts. There are big enhancements to Waterfall and Rotated Waterfall charts, there are new chart resizing and alignment features, and Loess Smoothing can now perform moving quadratic regression. This is not a major upgrade, but it seems like more than a minor one.

Build 3009 remedies this and adds a bit of flexibility to box plot source data. Note: A minor bug was added in Build 3008 and an old bug was supposed to be fixed but wasn’t. If you are using an earlier build and you want to update to 3008 3009, send me an email. Peltier Tech Charts for Excel has been updated to Build 3008 3009, on 11 April 2016 17 April 2016.

Peltier tech charts for excel 3.0