OfficeReports provides a few example layouts when installed. When you select a layout, it is displayed right to the Layout pane.
New layouts can be added and existing layouts can be adjusted and copied.
By default the general chart layouts are only available in PowerPoint. In Excel, we recommend using standard Excel chart layouts.
Select a chart layout and a chart based on example date is displayed right to the OfficeReports Layout pane.
Click on the selected chart and the Excel menu will focus on ‘Chart Tools’ where Design, Layout and Format can be adjusted:
Change chart type, and chart layout
Titles, Axis titles, Legend, Data labels, Axis, Gridlines, Plot Area
Shape styles, shape fill, shape outline etc.
When the chart is edited, press ‘Save’.
Defines the default Width and Height of charts. When you in PowerPoint add a chart to a placeholder, the size of placeholder will define the size of the chart.
Number of Decimals
Percentages: Select the number of Decimals needed for tables and charts.
Mean and Std. Deviation:
Select the number of Decimals needed for tables and charts.
Run Excel macro:
If the specific chart type involves an Excel-macro please write the name of the macro. (Read more: Adding Macros to OfficeReports tables and charts)
Run Significance macro:
If the specific chart type involves an Excel-macro please write the name of the macro. (Read more in Appendix 3: Adding Macros to OfficeReports tables and charts)
Layout only available for:
A specific chart style might be only relevant for frequencies or crosstab charts. Select in which context a type should be available.
Some macros require that the content of a table is specifically Percentages, Observations or Means, or/and Percentages are calculated by the Column/Row/Total.
In some situations, it is useful that the settings in Options are disabled as a change in settings might affect the macro.
If we want to make customized OfficeReports chart types available to other users we can export the chart type files (or layout-files) and make them available to other users – Or if we need a chart type defined by another user, we can import it here.