Charts are a way of illustrating data in order to make it easy to spot trends and patterns. Most types of charts are simply a collection of points on a grid, with interstitial designs and labels that make them easier to read.
By default, charts are generated dynamically, based on data points that come from Data Fields. Each data field can be thought of as a "series" of data, which have a common association and are connected in some way. When we put one data field on a chart, we have a single-series chart, which is useful for comparing values to each other. When we put multiple data fields on a chart, we have a multi-series chart, which is useful for comparing trends.
Before creating a chart, make sure that your data exists in cells on the report. These cells don't have to be visible, so you can suppress them if desired. Charts are interactive in the Report Viewer, but will appear as static images in PDF, RTF, and Excel formats (CSV is incompatible).
To insert a chart into a report, select a Group Footer or Report Footer cell and press the Chart Wizard button. The Chart Wizard dialog will open.
The Chart Wizard has four tabs: Type, Data, Appearance, and Size and Preview. You can navigate between the tabs by clicking on the tab, or using the Previous and
Next buttons.
The Type Tab lays out all the available types of charts you can create. There are 20 types, sorted into five general categories. Click on a category header to see more information about that type.
Click on a chart for more information about each type.
![]() |
![]() |
![]() |
![]() |
![]() |
|
||
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
|
Combination Charts (v2016.3) |
|||||||
![]() |
|
Line charts display series of data points on a grid, connected by straight lines. They are often used to display a trend over time.
Each series on a line chart is represented as a colored line. Line charts can have up to three Y-axes.
Variations:
Bar charts use rectangular bars which extend horizontally left to right to show comparisons between categories. Column charts use vertical bars which extend upward. The length of a bar represents the quantity of the data value.
Each series on a bar or column chart is represented by a colored set of bars.
Variations:
Pie charts are used to show the relationship of data values in a series as portions of the total. The area of each slice is proportional to the quantity.
Each data value on a pie chart is represented by a colored "slice". Pie charts are single-series only.
Variations:
Scatter charts use pairs of data fields with a common relation to generate coordinates as points on a grid. They are often used to find relationships between two variables in a set of data. Unlike most other report types, scatter charts often map data from detail rows, instead of group rows.
Each series on a scatter chart is represented by a different shape and color combination.
Variations:
(v2016.3) Combination charts are several different charts layered on top of one another. They comprise a combination of Column, Line, Area, and/or Stacked Column charts. (Column and Stacked Column charts are not compatible with each other). Combination charts can have up to two Y-axes.
The Data Tab is used to specify which cells to use as chart data. You can change how data is translated into points by changing the data layout. You can also choose a sort order, as well as upper and lower boundaries for the data and axes.
Add series to the chart by selecting a Data Field containing numeric values from the Series Values dropdown menu. Some charts may require you to select a data field to label the X-Axis. Some charts may ask for two or three data fields per series. The data axis is drawn automatically.
NOTE. Data is on the Y-Axis; this may not always be the vertical axis. Labels are on the X-Axis; this may not always be the horizontal axis. Scatter charts have no labels axis, but have X- and Y- data axes.
Add additional series by pressing the Add Series button (disabled for single-series charts). Give a Name to each series. Press
to remove a series.
Change the data layout by pressing the Data Layout... button. This will open the Data Layout dialog. If you change the data layout, this section will change for you to add either individual points, or groups of series, instead of adding individual series. See Data Layout for details.
Use the Sort data by dropdown to determine how series data should be ordered:
You can sort data in Ascending (A- Z, 0-9) or Descending (Z-A, 9-0) order.
Use the Exclude values fields to ignore values that are too large and/or too small.
(Grid charts) Use the Data Axis Value fields to set upper and/or lower bounds for the data axis.
(Grid charts) Check Align Data Labels Across Series if you have multiple series with data points at common intervals.
(Pie charts) Use the Other Category Percent field to group data fields with small quantities into an "Other" category.
Your data may not fit neatly into series. This dialog accommodates different data layouts by allowing you to select from a couple of different ways to build a chart.
Column Based Chart is the default. This layout builds charts by taking data fields, and mapping selected values as Y-coordinates on the data axis. Determine which values are selected by specifying a data field with a common relation as the X-axis. This layout is useful if you want to plot one or more unrelated series in a group (e.g. Budget and Sales and Expenditures per Store).
Use Column Based Chart if... Your report contains a group with one or more elements. For example:
Row Based Chart is a little more complex. This layout still uses fields as series, but all your series are a group, nested within another group which determines the X-axis values. Data values are mapped per series per group. This layout is useful if you want to plot two or more related series in a group (e.g. Sales per Employee per Store).
Use Row Based Chart if... Your report contains a group within a group. For example:
If you select this layout, the data selector will change to allow you to add all your series as a group, nested within an outer group for the data labels:
Cell Based Chart is the simplest option. This layout builds charts by taking pairs of static report values, and using them as (X,Y) or (label, value) coordinate pairs.
In order for the chart wizard to recognize report cells, they must be in Formula form, with a preceding = sign, text surrounded by quotes, and data fields surrounded by braces { }. Examples:
Use Cell Based Chart if... You want to build a chart point by point, and only have one data series. For example:
If you select this layout, the data selector will change to allow you to add points. This layout only supports one series of data (duplicating data labels will create duplicate axis labels):
The Appearance Tab contains options for customizing how the chart will look.
Use the Colors dropdown to select a color theme to apply to the chart. Specify a custom range of colors by selecting the Linear Range option.
Check Use 3D Style to give your chart a three-dimensional look.
Chart Title – Enter the text you want to appear in at the top of the chart.
(Grid charts) X-Axis Title – Enter the text you want to appear on the X-Axis (horizontal axis).
(Grid charts) Y-Axis Title – Enter the text you want to appear on the Y-Axis (vertical axis).
Use the Point Labels dropdown to label the points on the chart:
Use the Legend Position dropdown to choose where to display the legend relative to the chart.
Use the Label Font dropdown to specify the font for the labels.
Use the Number Format... dialog to specify how data and axis labels should be formatted:
(Line & combo charts) (v2016.3) Use the Chart Axes button to add and format axes:
Use the Benchmark Lines... dialog to add horizontal lines at specific sections of the chart:
This section allows you to customize a variety of attributes. The following attributes are supported:
To add a customization, select an attribute from the dropdown menu and press Add Attribute. Then enter a custom property into the attribute field or select from the attribute dropdown menu.
Press to remove a customization.
This section allows an experienced user to add FusionCharts customizations.
NOTE. Recommended for advanced users only. Not all attributes may be supported.
See Fusion Chart Attributes for available customizations. Attributes differ depending on the type of chart. To see available attributes, select a chart type, then scroll down and expand a category. Property values generally need to be of a certain type and within a certain range.
To add a customization, enter the attribute name, then press Add Attribute. Then enter a custom property into the attribute field.
Press to remove a customization.
The Size and Preview Tab allows you to change the size of the chart and preview any customizations.
NOTE. Chart previews in the Wizard and on the Design Grid use placeholder data.
You can change the size of the chart in one of three ways: