For each table OfficeReports will display a default chart type. The default type can be overruled by selecting an alternative type. Defaults and alternatives are defined in the Layout section.
If you edit an OfficeReports chart and you want to keep this layout even when you update the report or the chart by any reason, you must checkmark the ‘Keep the current layout’.
If you edit texts in an OfficeReports chart and you want to keep this text even when you update the report or the chart by any reason, you must checkmark the ‘Keep the current text’.
The “Align” function perfectly aligns a chart with the chart below it. The charts get the same size, and the axes of both charts will overlap each other. Handy when you e.g. need a line chart on top of a bar chart. (Is not working in Excel)
This short video shows how: Aligning two charts
For charts containing just one variable OfficeReports default add the variable text to a chart, but this can be overruled by adding an alternative title.
For charts containing two variables (variable and optional variable) there are a number of alternatives how to process a title:
The title can be:
- Variable text
- Optional variable text
- Variable text x Optional variable text
- Optional variable text x Variable text
- User defined title
The default setting for the title is defined in the Layout section.
Adds an Axis Title, Values
Adds an Axis Title, Categories
Having defined a cross chart showing the percentage distribution for the primary variable ‘I understand my benefit plan’ (Strongly Agree – Strongly Disagree) either shows the Percentages grouped by Gender or by the rating on the scale. Switch Row Column changes from the one to the other:
With this feature OfficeReports will set minimum and maximum to the value axis.