How to: Add Data to a Chart

SQL Server 2008 Books Online (October 2007)

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

To add data to the chart, you must add fields to the category and value axes. See the Working with Chart Data Regions topic for a visual representation of how these axes relate to regions on the chart.

There are two ways to add data to a chart: you can drag and drop fields from your dataset, or you can use the Property Dialog.

To add data to a chart from the Data pane

From the Data pane, drag a category field onto the category data region.
From the Data pane, drag a value field onto the value data region.
(Optional) From the Data pane, drag a series field onto the series data region.

To add data to a chart from the Chart Properties dialog box

In Design view, right-click the chart and click Properties.
Click Data on the Chart Properties dialog box and, for Dataset name, select a dataset to use for the chart.

In Values, click the Add button.

Note:
The values list provides data for the chart. For example, in a column chart, data from the values list determines the height of the columns and the labels on the y-axis of the chart.

On the Values tab of the Edit Chart Value dialog box, do the following:

In Legend label, type a title or expression that evaluates to a title that will be shown in the legend for the value series.

In the Value Field, type or select a field expression to use for the value series.

Note:
Depending on the type of chart, the Values tab may contain more than one value box, each with different names. For example, a Bubble chart uses two value boxes labeled Bubble and Bubble Size.

Note:
If you are grouping data, use an aggregate function with the field expression. For example, to summarizes sales by product category, use the Sum function with the sales field.

Click OK.

Repeat steps 3 and 4 to add another value series.

In Category Groups, click Add. The Grouping and Sorting Properties dialog box opens.

Note:
The category group list is used to provide groups of data in the chart. For example, in a column chart, data from the categories list is used to determine the number of columns and the labels on the x axis of the chart.

In Name, type a name for the category group.
In Group on, type or select a field expression to group by.
1. In Label, type or select an expression to use as the category label.
  
  Note:
  Use Grouping Label to place a label on the chart for the category. For example, in a column chart, the value of Label is placed on the X axis to describe each column.
2. Click OK.
Repeat steps 7 and 8 to add another category group.

Note:
Use Grouping Label to place a label on the chart for the category. For example, in a column chart, the value of Label is placed on the X axis to describe each column.

(Optional) In Series Groups, click Add.

Note:
Series groups are optional. The series group list is used to provide dynamic groups of data in the chart. For example, in a column chart, data from the categories list will result in a column for each series group, in each category.

(Optional) In the Grouping and Sorting Properties dialog, do the following:
1. In Name, type a name for the series group.
2. In Group on, type or select a field expression to group by.
3. In Label, type or select an expression to use as the series label.
  
  Note:
  Use Grouping Label to place a label on the chart for the series. For example, in a column chart, the value of Label is placed in the legend to describe each column.
4. Click OK.
(Optional) Repeat steps 10 and 11 to add additional series groups.

Note:
Use Grouping Label to place a label on the chart for the series. For example, in a column chart, the value of Label is placed in the legend to describe each column.

Concepts

Other Resources

Help and Information