Configuring charts & tables in a printed report

Configure your Charts and Tables to your business needs with our guide on setting Report Types, Date Ranges, Data Sources and picking delightful Titles and Subtitles.

Written by Ross MacLeod

After adding charts and tables it’s time to start configuring them to your business needs. In this article you’ll learn about:

  • Editing page elements
  • Setting titles and subtitles
  • Different report types
  • Selecting a report type
  • Picking data ranges
  • Choosing a data source

Editing page elements

After adding a template, chart, table or text element to a report, we give you complete control to decide what data you want to display, how and for what period. To start configuring an element, hover your mouse over it and select Edit:

Editing Page Elements

Setting titles and subtitles

You can add titles and subtitles to your charts and tables in order to describe what you’re reporting on. For example, you may want to title a report focusing on your cashflow as a ‘Cashflow report’, a report on your incomes as a ‘Breakdown of Incomes’ and a report concentrating on a particular KPI, after the KPI. We wouldn’t recommend using this space to add commentary or annotation – that should be put in the annotation section of the chart or table. More on that later!

Setting Title and Sub title
You can quickly and easily set titles and subtitles using the panel on the righthand side. Anything you enter will be reflected live on the preview on the left. In our example below we’ve gone for the imaginative ‘Example Title’ and ‘Example Subtitle’, but we’re sure you can think of something better when crafting your own reports!

A Report with a Title and Sub title added

About report types

Report

This is the default report-type for both charts and tables and your go-to option in most scenarios. A report can be used to focus on almost anything, from your incomes over the past 7 days to a forecasted picture of your projected cashflow.

Example Report

Comparison

As the name implies, a comparison report allows you to compare performance. You can use a comparison report to view performance versus budget or target or scenario versus scenario.

Example Comparison

Tracking

A tracking report allows you to report on Xero tracking and Quickbooks classes and location data. Using a tracking report you can drill into the detail of tracked items, create formulas for tracked data and truly see under the hood of any business.

Example Tracking

Proportion

Using a proportion report you can create a proportional breakdown of the data you’ve added to your report, whether it be a percentage breakdown of costs or one KPI against another. Proportion reports come in two flavours – pie or doughnut – and can only be used with charts, not tables.

Proportion Card Examples

Selecting a report type

You can quickly select between different report types when a chart or table is in edit mode. Any change you make will be instantly reflected in the page preview, but crucially, not saved. If you change your mind you can always hit discard changes in the top right!

Selecting Report Types

Picking a date range

We give you amazing flexibility to report on the data which matters to you, when it matters to you and in the way that matters to you, and date ranges are no exception. Any chart or table you create can report on data daily, weekly, fortnightly, four-weekly, monthly, quarterly or yearly. By default any date range you select will be relative (either previous to or following from) the default date you selected when creating your report. However you can override this on an individual basis by pressing ‘Set Custom date’.

Picking a Date Range

Choosing a data source

As an all-in-one reporting and forecasting solution, we allow you to both report on the past and look to the future. Use the Data Source option to display actual data, forecast data or a combination of Forecast and Actual data, and start gaining greater insight into both your business past and present, and your business future.

Selecting Data Source