Sign up ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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)?

share|improve this question
I don't think you can do it in the chart web part so your looking at 3rd party stuff. –  Ryan Feb 28 '12 at 20:22

5 Answers 5

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

share|improve this answer

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

share|improve this answer

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:

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.

share|improve this answer


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.

share|improve this answer

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.

share|improve this answer
Unfortunately a calculated column won't help for data aggregation across items. –  Christophe Mar 28 '14 at 16:01
True, you would need to resort to other means. –  C. Marius - MVP Mar 28 '14 at 18:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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