Charts
Last updated
Last updated
In the header and footer, you can add all the inline charts such as sparklines, bullets, range plots, dot plots, and other unique charts such as donut charts and progress bars. Let's take a detailed look.
STEP 1: Click on Header & Footer option in the Design tab. Choose Chart from the Type dropdown.
STEP 2: You can choose whether to replace the current container or insert the chart into a new container that is to the right/left/top/bottom of the current container. Let's insert a chart to the right of the existing cell.
STEP 4: A bullet chart gets inserted by default as we have 3 measures. If you have a single measure, a bar chart is inserted.
STEP 5: The Customize ribbon is enabled when a chart is inserted. We've changed the chart to a donut chart. Learn more about header chart customizations.
Note that by default, the table is greyed out as shown in the image.
On hovering over the chart, the data selection button appears.
Click on the change data symbol to open the 'Data Selection' dialog box. The data source used to render the chart can be set using the methods listed below:
- Using data from rows
- Using data from columns
- Manually selecting the cells required for the chart
STEP 1: To render the chart using row data, click the Row button. You can manually select the row categories that will contribute to rendering the chart.
Click on the 'Clear' link to reset and remove all the selected rows
STEP 2: After clicking OK, notice that the rows used as the data source for the chart have been highlighted.
STEP 1: To render the chart using column data, click the Column button.
STEP 2: Use the checkboxes to select the column dimensions and select measures from the dropdown. These dimensions and measures will be used to render the chart.
Click on 'Clear' to reset and remove the columns that have been selected.
We've also opted to change the chart type to a bullet. Notice that the columns used as data source for the chart have been highlighted.
STEP 1: To render the chart using manual data selection, click the Manual button.
You have 3 options for manually selecting the data for header charts:
Dynamic: You can select rows from the table to populate the chart on the fly. The chart is rendered dynamically as the selection changes.
Partial select: The selected rows are shown as a portion of the grand total row in the chart, essentially the grand total and the contribution of the selected rows.
Random selection: You can manually select individual cells that will be used to drive the chart. Each selection will be rendered as a separate bar.
There are a number of chart types like Donut, Sparkline, Bullet, etc. that can be inserted in the header. Let's see how to add or change them.
Changing the chart type
If your report has a single measure, a bar chart is inserted in the header by default. For two measures or more, a bullet chart is the default chart. This can be changed from the Data Selection dialog box.
Some chart variants are not shown here but can be accessed from the toolbar.
We've changed the bullet chart to a donut.
Browsing chart types
Use the arrow buttons on either end of the header to browse the supported chart types and select the one best suited to visualize your data.
View and select charts from the toolbar
You can also view and select all the supported chart types and their variants from the toolbar as shown in the image below.
Progress bar charts
If two data points are selected, you can also use variants of the progress bar such as conditional bar, angular bar, and donut bar.
Most customization options are already covered in the working with charts section. The customization options unique to header charts are covered here.
By default, the legend is shown on the right of the chart, you can change the position to the left or turn it off. Click the Legend config button in the Customize ribbon to change the legend.
When the legend is turned off, the chart will be rendered as shown in the image below.
The appearance of the donut chart can be customized by clicking on the Appearance option. You can select the color for each arc, set the arc size, and apply a gradient.
When a gradient is applied, you can select the gradient color, and the chart gets updated as shown.
When more than 5 categories are selected, the 'Enable others' option is activated. Even though six regions were selected, only five are displayed in the chart. When the 'Enable others' property is set, you can see a segment in the donut called 'Others' which visualizes the sum of the values apart from the top 5 categories. That is, if there are 10 categories added, the last 5 categories will be consolidated and shown as 'Others'.
The name 'Others' can be modified by clicking the 'Pencil' icon and entering a relevant name in the text field.
The arc size can be customized using the 'Arc size' dropdown. The available options are Small, Medium, Large, and Extra large.
Progress bar appearance can be customized as shown below. You can define positive and negative colors using a color picker.
In the sparkline customization toolbar, explanations for Appearance, Null display, Marker, and Show label are covered in the Working with charts section.
Let's look at the Data config option.
i) Select the row grand total and choose the sparkline chart type with the area spline variant. You can see the sparkline chart in the header as shown below.
ii) Click Data config. In the dialog box, you can see that all the measures are selected. Let's display only the Unit Price measure in the header. Uncheck the other checkboxes. Select a different color using the color picker if needed. Notice how the chart gets updated.
In the next section, we'll be covering adding KPI cards.
