Configure a chart

Once you've added your web part to a page, click the Edit button to display the properties:

The properties pane will now appear on the right.

In the properties pane, select a chart type add the URL to the SharePoint List containing the raw data you want to visualize:

As you enter the list URL you'll be presented with drop-downs containing your list fields.

Field containing the numerical data

This is the field which will be used for the Y axis, or will be used to represent the size of 'slices' in the case of a pie chart. It's the primary data you want to visualize. In this case, we've picked Revenue, and it'll be reflected in the size of the bars:

Field containing the categories or groupings

This is the field which will be used for the X axis, or the labels for the separate 'slices' in the case of a pie chart. It's the field which will be used to group together and aggregate the numerical data.

Aggregation

By default, the SUM aggregation is applied. This will add together every value for each grouping:

Aggregations available are:

• None: no aggregation. Every individual list item is rendered as a data point.

• Sum: adds each numerical item, grouped by the 'grouping' column

• Item Count: number of items for each group

• Average: average value within each group

• Maximum: max value within each group

• Minimum: min value within each group

• Standard deviation: the standard deviation within the group

• Variance: the variance within each group

Secondary Grouping

You may wish to visualise sub-categories for each category in the data. For example, the chart above displays Revenue by region. However, you may want to further break the values down by another field - in this case sales stage: