# Configure a chart

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

![](https://2862469232-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M9dDlLIQkrUpGsZtrA4%2F-MASsZxz-USTdu21i1Ap%2F-MASslcLTKYng1NgGsKV%2Fimage.png?alt=media\&token=703842a8-7bbe-4b4b-a7b8-68823eef87b7)

The **properties pane** will now appear on the right.

![](https://2862469232-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M9dDlLIQkrUpGsZtrA4%2F-MASsZxz-USTdu21i1Ap%2F-MASt3lHd3hEO4HkB8g4%2Fimage.png?alt=media\&token=589552e0-96b4-4543-9c29-9e138dd54f88)

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

![](https://2862469232-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M9dDlLIQkrUpGsZtrA4%2F-MASsZxz-USTdu21i1Ap%2F-MAStNTeef682LXG9zku%2Fimage.png?alt=media\&token=89fd7150-af9f-42bf-adbc-b491f4d9fd11)

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:

![](https://2862469232-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M9dDlLIQkrUpGsZtrA4%2F-MASuZgS8Fgkzwc4OdNw%2F-MAT2QcFoxZHORFkl07a%2Fimage.png?alt=media\&token=f6f95981-c1e5-476d-82ff-ab217dc3baff)

### 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:

![](https://2862469232-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M9dDlLIQkrUpGsZtrA4%2F-MASuZgS8Fgkzwc4OdNw%2F-MAT34zSMiu9V9ciDfz4%2Fimage.png?alt=media\&token=03803569-410c-482a-9c54-bb6bece156f3)

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**:

![](https://2862469232-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M9dDlLIQkrUpGsZtrA4%2F-MASuZgS8Fgkzwc4OdNw%2F-MAT5VWjJ9AULoEQUORI%2Fimage.png?alt=media\&token=1fc17147-576e-4ba8-a7ac-f74a0d4b2179)

![Revenue by region and sales stage](https://2862469232-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M9dDlLIQkrUpGsZtrA4%2F-MASuZgS8Fgkzwc4OdNw%2F-MAT5_w5uAeC9ygDMEMY%2Fimage.png?alt=media\&token=9d922980-3c53-4a19-8369-68e33f41ce85)