I have a list with the following sample data:

Title  |  Rank1   |    Rank2
Foo    |    2     |      4
Foo    |    4     |      6
Foo    |    6     |      8

Trying to construct a Column Chart around just "Rank1" data as an aggregated average. For example, expecting a single column to appear with the value of "4" (the average between 2, 4, and 6).

Is this possible using the Chart Web Part? Do I need to somehow configure something in the Advanced Properties? Does the Chart Web Part not do any aggregations like this? Would I have to pre-aggregate the data somehow (like putting into a separate list)?

  • I don't think you can do it in the chart web part so your looking at 3rd party stuff.
    – Ryan
    Feb 28, 2012 at 20:22

6 Answers 6


Chart Web Part does not do Aggregations, only displays tabular data. I would suggest you create a calculated column that performs the aggregation and than use the Chart Web part pointing to that new column.

One alternative is to go for Performance Point if you have Enterprise License.

  • 1
    Unfortunately a calculated column won't help for data aggregation across items.
    – Christophe
    Mar 28, 2014 at 16:01
  • True, you would need to resort to other means. Mar 28, 2014 at 18:39

Plumsail Dashboard Designer supports aggregation and grouping as well. Also, it works in Office 365 and SharePoint on-premises. Not free but good value for price - flexibility, modern view, animation, interactivity, and no coding.



Try Visifire for SharePoint webpart. This user friendly webpart will let you quickly create silverlight charts. The Visifire for SharePoint supports Group Data functionality using which you will be able to achieve your requirement as you have mentioned above. Please check out the documentation link below on how to group data.

enter image description here


Full disclosure: I have been involved in the development of Visifire for Sharepoint webpart.


The Chart Web Part doesn't do aggregation.

My company offers a solution that does charting of data aggregation and allows drill-downs. Here is a demo: http://blog.pathtosharepoint.com/2012/11/06/interactive-demo-charting-in-sharepoint/

It relies on the out of the box "Totals" available in SharePoint views.

Another option would be Excel services, but it is a multi-step process as you would have to transfer your data to Excel.


Look into SQL Report Builder. It works well with SP2010 lists, and be displayed on a SharePoint site rather easily.


Another 3rd party chart web part for those who are researching this is Collabion. similar to Nevron, it enables grouping of data

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.