Chart Add-ons
Add commonly used chart features and decorations to existing charts with ease
Growth Arrow
Macabacus Growth Arrows provide finance professionals with a dynamic, data-driven way to visualize growth trends in financial charts. Unlike manually drawn Office shapes, which require tedious formatting and do not update with data changes, Macabacus Growth Arrows are fully formula-driven and update automatically when underlying data changes.
Macabacus adds growth arrows as a new data series. To add a growth arrow, select your stacked or clustered column chart and click . Customize the arrow in the resulting dialog, with preferences saved for future use. Pressing Save
will insert the cells and calculations required to drive the dynamic arrow.
Macabacus Growth Arrows are added as a new data series that automatically updates with data changes. To add a Growth Arrow:
- Select your stacked or clustered column chart.
- Click
Macabacus > Charts > Growth Arrow
. - Choose to manually add Growth Arrows or use the
Reccomend
button for automated suggestions. - Customize the arrow in the resulting dialog, including size, labels, formatting, and positioning, with preferences saved for future use.
- Press
Save
to insert the necessary calculations and dynamically link the Growth Arrows to your chart data.
Accepted chart types
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 based on chart data. You can override this by entering a growth rate manually or selecting a cell containing the desired rate. Adjust the arrow and its data label formatting, and position the arrow to avoid overlap with other chart elements.
The growth arrow dialogue also allows you to select a starting and an ending period for each respective arrow.
Excel Table Bug
If a chart with data structured as a table (not to be confused with a TABLE() formula array) has a fixed growth arrow, the arrow may disappear when exporting the chart to PowerPoint/Word or copying the worksheet. This Excel bug has two workarounds: (a) convert the table to a range before performing these operations, or (b) use dynamic growth arrows.
This documentation refers to the latest Macabacus version. 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.