Adding totals to the tops of stacked column charts, or to the right of stacked bar charts, using native Excel functionality is cumbersome. Macabacus expedites this process and adds totals with a click of a button in the
Macabacus > Charts > Stacked Column / Bar Totals menu. This tool contemplates and addresses three possible scenarios:
Add a statistic (average or median) or arbitrary value line to a single-series clustered or stacked column or bar chart or certain types of line charts. Access this tool from the
Macabacus > Charts > Stat Line menu.
Add a target / threshold band with upper and lower bounds to column, bar, line, and scatter charts. Access this tool using the
Macabacus > Charts > Target Band button.
Many column-based charts include growth arrows above the columns showing a CAGR or other growth rate. Often, these arrows are hastily and imprecisely drawn on top of charts as Office shapes, require tedious formatting, and do not update when the underlying data changes.
Macabacus adds growth arrows to your column charts as a new data series. To add a growth arrow, select your stacked or clustered column chart and click the
Macabacus > Charts > Growth Arrow button. The resulting dialog presents you with several options for customizing the growth arrow, and your preferences are saved for the next time you use this tool.
Growth Arrow works with stacked column and clustered column charts, only. If you add a growth arrow to a clustered column chart, only the first clustered column series will be used to compute the growth arrow.
The Growth Arrow dialog computes a CAGR automatically based on the chart data. You can override this computed CAGR by manually entering a growth rate, or by selecting a cell containing the growth rate you want to appear in the arrow's data label. You can adjust the formatting of the arrow and its data label in this dialog, as well as adjust the position of the arrow to avoid overlap with other chart elements, for example.
Macabacus lets you add the growth arrow as either a dynamic series linked to worksheet data, or a fixed (i.e., static) series that does not update when chart data changes. A dynamic series uses formulas to position the arrow on the chart, just like any normal data-driven chart series. To create a dynamic arrow, Macabacus adds a few rows to your worksheet (preferably adjacent to the existing chart data) containing formulas that compute the growth arrow position. A static arrow, on the other hand, is "hardcoded" into the chart, but can be updated by simply reopening and closing the Growth Arrow dialog. A static arrow may be appropriate for a "quick-and-dirty" CAGR arrow on a chart whose data you do not expect to change, or if you want to avoid worksheet changes required by a dynamic arrow.
Excel 2010 is missing some charting features present in newer versions, so some Growth Arrow features are unavailable in that version of Excel.
If a chart whose data is structured as a table (not to be confused with a TABLE() formula array) contains a fixed growth arrow, the arrow may disappear if you export the chart as a picture to PowerPoint/Word using Macabacus, or even natively copy the worksheet on which the chart resides (the arrow will be missing in the chart on the new sheet, but remain on the original chart). This is due to an Excel bug for which there are two workarounds: (a) convert the chart data table to a range prior to performing these operations, or (b) use dynamic growth arrows.
This documentation refers to Macabacus version 9.1.9. Some features and descriptions of these features may not
apply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.