Take the 2-minute tour ×
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

7 Answers 7

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

You can achieve this with Nevron Chart Web Part and the built-in pivot aggregation. The Nevron Pivot Engine stays behind all data aggregation / analysis features provided by the web part. It uses formula expressions, which gives you flexible control over grouping, filtering and sorting and also provides the ability to define dynamic property values based on formulas.

For your requirement, you can use a pivot function to return the average of a set of numbers. For example, you can have category goruping by Title and two Values grouping for Rank1 and Rank2, with the following expressions:

For more information on the Pivot capabilities, you can refer to the Help Documentation:
Pivot Engine >> Grouping, Filtering and Sorting
Pivot Engine >> Functions

Full disclosure: I am working at Nevron Software and I have been assisting with the development of the Chart web part based on user requirements.

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

I am supporting the first answer you received here from Mr. Christo Bahchevanov, who also helped me with some issues I have (great technical support there). I have also recommended Nevron to other friends and customers, as the functionality it has can sometimes be a life saver! Especially when at the beginning you think you need something simple and then all of the sudden you realize you need better functionality!

Full Disclosure: Just a happy bubbly customer :)

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

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

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

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.