get vertical axis lines on excel for macbook

These limitations prevent you from exporting these new chart types to PowerPoint / Word using Macabacus (and other add-ins), for example. The key advantages of native waterfall charts are that (a) no additional calculations are required, and (b) you can set colors for each 'up' and 'down' bar individually.Īdditionally, at the time of this writing, the native waterfall and other chart types introduced in Excel 2016 are buggy and lack key functionality found in other chart types.

The key advantages of Macabacus waterfall charts are (a) Macabacus' intuitive data structure does not require you to explicitly identify data points as totals (b) Macabacus remembers your last used waterfall chart settings, including colors and (c) Macabacus' optional connector or 'bridge' lines look better and can be formatted.

You can customize the three colors used in waterfall charts, and optionally show 'bridge lines' connecting the tops/bottoms of columns shown in the chart to facilitate visual interpretation of the chart.Įxcel 2016 added the ability to create waterfall charts natively. Chart options let you display labels in different positions-like centered on data points or above/below adjustments depending on whether adjustments are positive or negative. To insert a waterfall chart, click the Macabacus > Charts > Waterfall Chart button. Waterfall charts, also known as bridge charts, are often used to show adjustments driving changes in a single metric (e.g., net income) from one period to another. All Quick Charts are 100% native-no proprietary objects are used to create them that would render them unusable by anyone who does not have Macabacus installed.īecause Macabacus adds calculations and in-worksheet chart options to the workbook when building most Quick Charts, most Quick Charts are created on new worksheets so that these modifications do not interfere with the structure of the worksheet containing the original chart data.

Get vertical axis lines on excel for macbook