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

  • 1
    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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.