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 below data in custom list

State
A1
A1
A1
A2
A2
A3

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
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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.