SharePoint Experts Blog

Adding more series to a SharePoint Chart with Dashboard Designer


Today we’d like to talk about our new feature introduced as part of our recent release of SharePoint Dashboard Designer 2.6.0. It is the ability to display a practically unlimited number of series on one graph. Such series may be based on entirely different list columns or may have, say, a common category but separate value fields.

Let’s take a look at an example.

Producing totals for multiple columns

Say, you have a table like this one:

SharePoint List View

And you want to produce totals for the income and the revenue columns over all entities:

Chart displaying aggregate values over all items in a SharePoint List

For this you will need to perform the following configuration steps in Dashboard Designer:

  1. Retrieve data from your SharePoint list in Data Source → SharePoint list
  2. Clear the Group By column in Data Source → Aggregation
  3. Click Process
  4. In Dashboarde → Chart your configuration will need to look like this:

Aggregating SharePoint list items in Dashboard Designer

The picture is self-explanatory, however a couple of things to note:

  1. We’ve introduced a little dropdown box for every series field: it lists values like ‘const’, ‘field’, ‘sum’ and others. It is nothing more than either an aggregate function you can use on the field, the value of the field itself (the ‘field’ option) or an arbitrary constant value (the ‘const’ option). In our example all we did was create two categories: ‘Revenue’ and ‘Income’ (‘const’ fields). And used real list columns (called also ‘Revenue’ and ‘Income’) together with the ‘sum’ aggregate function to sum everything we have retrieved from the list.
  2. We’ve added the second series via the ‘Add series’ button, it can be used to add any amount of series – and you also have your Remove button to remove any series up until the last one.

Producing totals for multiple columns based on another column

So, what if we wanted to calculate total revenue and total income for each month from our sample data above?

Chart displaying aggregate values by months

Our steps will be exactly the same as in the previous example, except our chart configuration page will look a little different:

Aggregating SharePoint list items by months in Dashboard Designer

The only difference here is that we’re using real fields for categories instead of constant values (instead of ‘const’ in the Category dropdowns we have ‘field’ – so, instead of manually entered ‘Revenue’ and ‘Income’ categories we get real values from the Month list column).

Counting entries in multiple columns

And now let us do a slight variation on the previous example. For our sample data we’ll use a customer satisfaction survey list with three single-choice questions:

Survey Diagram in SharePoint

The above is a standard SharePoint graphical summary of our survey.

And our chart will look like this:


And this is out Chart configuration tab:

SharePoint survey chart configuration

The idea here is straight-forward:

  • Three series.
  • Name attribute is set. The name attribute is simple text that is displayed as the chart’s legend.
  • ‘count’ function counts the number of occurrences of AuthorID (it can be any field really – we use this to count the number of entities).

Posted in: Dashboard Designer, Products