Charts are a way of illustrating data in order to make it easy to spot trends and patterns. 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 click the Chart Wizard icon. The Chart Wizard dialog will
open.
Type
The Type page lays out all the available types of charts you can create. They are sorted into five general categories.
Data
The Data page 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 list. 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 clicking the
Add Series button (disabled for
single-series charts). Give a Name to each series.
Data Layout (advanced users)
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: Use if your report contains a group with one or more elements.
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).
Row Based Chart: Use if your report contains a group within a group
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).
Cell Based Chart: Use if you want to build a chart point by point, and only have one data series.
This layout builds charts by taking pairs of static report values, and using them as (X,Y) or (label, value) coordinate pairs.
For cell based charts to recognize report cells they must be in formula format:
Appearance
Use this page to customize how the chart looks, and add some additional features, such as axes and benchmark lines.
Colors
Select a color theme to apply to the chart. Specify a custom range of colors by selecting the Linear Range check box. Select Use 3D Style to give your chart a three-dimensional look.
Labels
There are several options for adding labels to places on the chart. Some options are only available for certain types of charts.
Advanced Features are recommended for advanced users. Ask your administrator for available features.