Macabacus makes it easy to conform a collection of charts to the same size, turning what would normally be a tedious, manual resizing process into a trivial exercise.
For precise control over chart sizing and positioning, use the Chart and Plot Size dialog. Here, you can apply Standard Sizes, manually adjust the dimensions of the chart and plot areas, fine-tune positioning of the plot area within the chart (which cannot be done with precision natively), and memorize/apply chart sizes. This tool is accessible from the Macabacus > Charts
menu.
Click the Macabacus > Charts > Memorize Chart
button to remember the selected chart's size, plot area size, and plot area position within the chart, and then apply these properties to other selected charts using buttons on the Macabacus > Charts > Apply Memorized
menu. This is a fast way to conform the appearance of multiple charts simultaneously.
Conform the selected chart to the dimensions of a Standard Size, the dimensions of a shape selected in PowerPoint or Word, or the selected range in Excel from the Macabacus > Charts > Resize To
menu.
When you resize a chart to a selected range of cells, Macabacus prompts you for the range address, showing the address of cells that were selected prior to selecting the chart as the default option. You can optionally reposition the chart to the top left coordinates of the range, "fitting" the chart within the specified range.
Stack selected charts relative to the first selected chart, and resize them to the dimensions of the first selected chart. This could come in handy when creating a dashboard, for example. Access this tool using the Macabacus > Charts > Stack Charts
button.
Use the Move Data Labels dialog at Macabacus > Charts > Move Data Labels
to adjust the position of data labels on a chart. You can adjust all data labels for a series, or individual data labels. This allows you to adjust data label positions with precision for pixel-perfect positioning. In contrast, Excel natively provides no means of adjusting data label position precisely or easily, requiring you to position data labels individually using imprecise mouse movements.
Replace missing chart data labels and/or axis labels at Macabacus > Charts > Replace Missing Labels
. In X-Y (scatter) and bubble charts, specifically, Excel does not automatically attach labels to data points. Macabacus can add text labels to both of these chart types, provided that the source data is properly formatted.
Add a data label to the last, first, maxmimum, and/or minimum data point of each series in a line graph or clustered column or bar chart by clicking the Macabacus > Charts > Label Points
button. Macabacus automatically removes the legend, if present, when you set the label text to the series name, since the legend would be redundant.
When creating scatter charts and bubble charts, Excel does not automatically attach the correct labels to data points. This tool adds the correct data labels to both these chart types, provided that the chart data is structured as follows:
Add additional columns as needed for more than two series. For bubble charts, specifically, the bubble size column must be the last column in the chart data. Access this tool at Macabacus > Charts > X-Y Scatter Labels
.
Match the number format of data labels to the number formats of source data by clicking the Macabacus > Charts > Link Number Formats
button.
Access the following tools from the Macabacus > Charts > Recolor Chart
menu.
Recolor series in selected charts to your default series colors customized in the Excel > Format > Colors
section of Macabacus' Settings
dialog. This is a quick way to apply your preferred color scheme, without having to deal with Office's more cumbersome chart templates. If you have six default chart series colors and a chart with eight series, for example, Macabacus applies the Series 1 color to Series 7 and the Series 2 color to Series 8.
Recolor data points in selected charts to the cell fill color of charts' source data. Cells with no fill color are ignored. Note that legends are not affected by this tool. This is because this tool recolors points, not series, and legends show series colors. If you need to recolor entire series, use Macabacus' other coloring tools or native functionality instead.
Recolor Recolor data label fonts to match their data point or marker colors. This is particularly useful for line and scatter charts. If a single series or data labels collection is selected, only that series' data labels will be recolored. If a single data label is selected, only that data label will be recolored. Otherwise, all data labels in selected charts will be recolored.
Apply number formatting to the maximum value on the selected chart's y-axis, only. Choose from dollars, euros, pounds, percentages, and multiples on the Macabacus > Charts > Y-Axis Max Format
menu. This turns off y-axis autoscaling, which could result in undesirable chart formatting if the chart's underlying data later changes. If the chart data does change, you can click Macabacus > Charts > Y-Axis Max Format > Re-scale Axis
to automatically re-scale the chart appropriately.
Save the selected charts as pictures—specifically, PNG images. If no chart is selected, all charts on the active worksheet will be saved as pictures. When you save multiple charts as pictures, the file name you specify is the "base" name to which Macabacus will append an index. For example, if you save two charts as pictures and specify the file name "Chart.png," Macabacus will name your images "Chart_001.png" and "Chart_002.png." Access this tool using the Macabacus > Charts > Save Chart as Picture
button, or from the Save as Picture
button on chart context menus.
See our discussion of this tool here.
This documentation refers to Macabacus version 9.4.5. 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.