Available for the following HR Classic plans: Premium, Platinum
Available for the following plans: Plus, Unlimited HR, Elite, Unlimited HR+Payroll
Available for the following users: All users
Charts in the Visualisations section of a custom report show the employee count from your report data. You can add 3 chart types: Column, Donut and Line. Each chart counts the same people as the report's data table, within the viewer's permissions.
Line charts are only available in the report canvas, and only when the report canvas is turned on for your organisation. They are not offered in the Build your own report wizard.
This article explains how to:
- Add a column chart
- Add a donut chart
- Add a line chart
- Rename, move, remove and save a chart
- Further information
Add a column chart
A column chart compares the employee count across the values of a field, such as teams, locations or employment types. It shows one column for each value of the field you choose.
- Log in to Employment Hero.
- Go to Reports > Create new. The report canvas opens.
- In the left panel, select the fields for your report from the data sources. Include the field you want to compare, such as a team or location field.
- In the Visualisations section, click + Add visualisation. The list of charts opens.
- Select Column. The list closes and a column chart card appears below any existing charts.
- In the chart card, click the field drop-down after Employee count by. The list shows the fields in your report that a column chart can group by.
- Select the field you want to compare. The chart preview shows one column for each value of that field.
Add a donut chart
A donut chart shows how the employee count splits across the values of a field, as parts of a whole. It shows one segment for each value of the field you choose.
- Log in to Employment Hero.
- Go to Reports > Create new. The report canvas opens.
- In the left panel, select the fields for your report from the data sources. Include the field you want to split the count by, such as an employment type field.
- In the Visualisations section, click + Add visualisation. The list of charts opens.
- Select Donut. The list closes and a donut chart card appears below any existing charts.
- In the chart card, click the field drop-down after Employee count by. The list shows the fields in your report that a donut chart can group by.
- Select the field you want to split the count by. The chart preview shows one segment for each value of that field.
Add a line chart
A line chart shows how the employee count changes across time periods or across the values of a field. If you group by a date field, you also choose a period: Day, Week, Month, Quarter or Year.
If your report uses data that Build your own report doesn't support yet, the Line option is not offered for that report. It becomes available once that data is added.
- Log in to Employment Hero.
- Go to Reports > Create new. The report canvas opens.
- In the left panel, select the fields for your report from the data sources. To show the count over time, include a date field.
- In the Visualisations section, click + Add visualisation. The list of charts opens.
- Select Line. The list closes and a line chart card appears below any existing charts. The field drop-down starts with the first date field in your report, or the first field the chart can group by if your report has no date field.
- To change the field, click the field drop-down after Employee count by. The list shows the date fields in your report and the fields a column chart can group by. It only lists fields you have permission to see.
- Select the field you want to group by.
- If you selected a date field, the Period drop-down appears. Click it and select Day, Week, Month, Quarter or Year. The period starts at Month. If you selected a field that is not a date, the Period drop-down is hidden.
- Check the chart preview. It updates as soon as you change the field or the period. For a date field, each point is one period, such as "Jan 2026" for Month or "Q1 2026" for Quarter. For any other field, each point is one value of that field.
Helpful Hint
The Period drop-down only shows when the line chart groups by a date field. A period with no people shows as a point at zero, and it is never hidden.
Rename, move, remove and save a chart
These steps are the same for Column, Donut and Line charts. Charts are saved with the report.
- Log in to Employment Hero.
- Go to Reports. Click Create new, or open a saved report and edit it.
- In the Visualisations section, click the pencil icon next to the chart title. You can also double-click the title.
- Type the new title.
- Press Enter to keep the new title. To cancel, press Esc.
- Log in to Employment Hero.
- Go to Reports. Click Create new, or open a saved report and edit it.
- In the Visualisations section, click and hold the move icon next to the chart title.
- Drag the chart card over another chart card. Three drop zones appear on that card.
- Drop the chart on the left zone to place it on the left, or on the right zone to place it on the right. Drop it on the middle zone to place it in a full-width row.
- Log in to Employment Hero.
- Go to Reports. Click Create new, or open a saved report and edit it.
- In the Visualisations section, point to the chart card you want to remove. The remove icon appears in the top-right corner of the card.
- Click the remove icon. The chart card is removed from the report.
- Log in to Employment Hero.
- Go to Reports. Click Create new, or open a saved report and edit it.
- Add, rename, move or remove charts as needed.
- Click Save in the top-right of the screen.
- Open the report from Reports. Each chart shows with its saved field, title and position. A line chart also keeps its saved period.
Further information
Owners and Admins can use charts in custom reports. Other users need the Use Custom Reports permission. To see or change a line chart, you also need access to Build your own report and to the rows in the report.
Each chart counts only the people and fields the viewer's own permissions allow, the same as the report's data table. Two people can see different counts on the same shared report. For example, a manager limited to their reporting line sees counts for only the people in their reporting line. A viewer limited to a set list of members, by team, location, worksite or exclusions, sees counts for only those members.
If you have no permission to see the chart's field, or no access to Build your own report or the report's rows, the card shows "You don't have access to the data in this chart."
If your permissions can't be loaded, the card shows "Unable to preview this chart." with a Try again button and no numbers. The chart never falls back to default access settings, so it will not show more than your permissions allow.
Column, Donut and Line charts hide any group that has 1 to 4 distinct people, however many rows the group has. The chart card then shows "Values are hidden to protect privacy."
- A group with zero people shows as zero and is not hidden.
- Some groups with 5 or more distinct people are also hidden. If only one value in a total is hidden, the smallest visible value in that total is hidden too. This continues until no more values need hiding, so a hidden count can't be worked out from the totals across periods.
- On a line chart, a hidden group shows as a gap in the line.
- If every group is hidden, the card shows the same privacy message.
When a chart passes a limit, the whole chart is replaced with a message. No partial data shows. Each limit is counted after the report's filters and the viewer's permissions.
- 50,000 people: applies to Column, Donut and Line charts. The card shows "This report has too many people for a chart. Add a filter to bring it to 50,000 people or fewer."
- 500 groups: applies to Column, Donut and Line charts. The card shows "This chart can't be shown because it has more than 500 groups."
- 366 periods: applies to a line chart grouped by a date field. The card shows "Choose a longer period to see this chart". To see the chart, select a longer period, such as Month instead of Day.
Up to the 500-group limit, every group is shown. Some axis labels are skipped so they don't overlap.
Chart limits replace the chart only. The export limit is a separate limit that applies to the report's rows.
- Export limit: counts the rows in the report. If a report has more than 50,000 rows, the PDF or CSV export is blocked with a message. The data table view is still open.
- Group limit in exports: if a chart has more than 500 groups, a PDF export shows the group-limit message in place of the chart, and the table rows still export. A CSV export includes no chart data, and the table rows still export.
Each export shows only the data your own permissions allow.
Each point on a line chart grouped by a date field is one period:
- Day: one calendar day, such as "5 Jan 2026".
- Week: Monday to Sunday. Weeks are numbered using the ISO standard, so "W1 2026" is the week that contains the first Thursday of 2026. That week runs from Monday 29 December 2025 to Sunday 4 January 2026.
- Month: one calendar month, such as "Jan 2026".
- Quarter: one calendar quarter. Q1 is January to March, such as "Q1 2026".
- Year: one calendar year, such as "2026".
With no date range filter, the chart shows every period from the first to the latest period with data. The axis never shows a period after the current period.
If the report has a date range filter, only people whose employee start date is in the range are counted. If the chart groups by employee start date, it shows every period from the filter's start period to its end period, or to the current period if that is earlier. If the chart groups by another date field, it shows every period from the first to the latest period with records among the filtered people.
If the filter's start date is after its end date, the chart shows the same records as the table, with no extra message.
A line chart places each record into a period using the same time zone rule as the data table.
- Date and time values are placed using the viewer's time zone. If the viewer has no time zone set, the organisation's time zone is used.
- Date-only values stay on their date, with no time zone change.
Because of this, two people in different time zones can see a record near midnight in different periods on the same shared chart.
When a line chart groups by a date field, it leaves out these rows:
- Rows with an empty value in the date field.
- Rows with a date before 1 January 1900, which are treated as placeholder dates.
- Rows dated after the current period.
For a field that is not a date, records with an empty value are handled the same way as on a column chart.
Rows left out of the chart still show in the data table.
- There is no data to display for this chart. The chart has nothing to count, for example when every row has an empty value in the chart's field.
- Add a category field from Data sources to plot this chart. Your report has no field the chart can group by. Add one from the data sources in the left panel.
- A field used in this chart has been removed. The chart's field was removed from the report. The field drop-down shows "Select field…", and the Period drop-down is hidden. Click Auto-fill, select a new field, or click Remove chart.
- Unable to preview this chart. The chart or your permissions failed to load. Click Try again to reload it.
- Unable to load chart field options. The list of fields failed to load. Click Try again.
No. Column, Donut and Line charts show the employee count for each group. There is no option to sum a field.