![]() When you orient the butterfly chart with category labels in the middle, Macabacus can handle chart data in multiple units. Several data label positioning options are also available. You can orient the chart with categories (e.g., sales, net income) on the left axis, or down the middle of the chart separating the two series of data being compared. To insert a butterfly chart, click the Macabacus > Charts > Butterfly Chart button. To insert a stacked column chart, click the Macabacus > Charts > Stacked Column Chart button.īutterfly charts, also known as tornado charts, are often used to compare similar metrics for two companies, business units, etc. Macabacus' stacked column chart is similar to those you create natively in Excel, except that you can (a) optionally include totals at the tops of the columns, (b) show percentages rather than amounts in the data labels (advisable when showing the vertical value axis and column totals), (c) omit data labels for small values where label text would otherwise overflow the bounds of the associated data point (i.e., block), and (d) automatically apply your Macabacus chart series colors. The "bonus line" lets you include a similar line at a value you specify, such as a price target or offering price. You can optionally show average and median lines that extend the width or height of the chart, as applicable, showing the average/median value of all ranges shown in the chart. These charts can be oriented as either bars (extending horizontally) or columns (extending vertically). To insert a football field chart, click the Macabacus > Charts > Football Field Chart button. These limitations prevent you from exporting these new chart types to PowerPoint / Word using Macabacus (and other add-ins), for example.įootball field charts, also known as floating bar/column charts, are often used to display valuation ranges computed using different valuation methods (e.g., P/E, EV/EBITDA, DCF). 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |