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

I have below data in custom list


Can I create below type of chart in Sharepoint 2010 where x axis is state and y axis is state occurrence.

enter image description here

share|improve this question
You can export to excel a list data and generate a chart with excel. If required, you can use the Excel Viewer web part to push on a web page this chart. – Steve B Jun 25 '12 at 12:13
No, not without code or additional services. The most straightforward way is, and I agree with Steve B, turn on Excel Services and load a static Excel Services webpart. This will require no-code, no-third party software, and minor configuration (if your list is in a XLSX file.) The second option is SSRS (for no code). g'luck. (Oh, on note about Excel Services: it requires Enterprise CALs.) – 1c1cle Jun 25 '12 at 13:01
:( It looks complicated.. – NotesArt Jun 25 '12 at 13:25
If you are willing to make State a lookup (A new list holding only the states) you can count occurrences its used in your current list – Anders Aune Jun 25 '12 at 16:19

Your Answer


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

Browse other questions tagged or ask your own question.