I am working in SharePoint 2010. I need to make a chart to represent how many projects we have from each division. We have a SharePoint list of our projects with a choice column of all the divisions.
What I need is a way to count how many of each choice there is and put this into another webpart/list that the chart web part can read in to display as a pie chart. I understand they could be counted manually but I'd like to automate it if possible so up to date information is always present.
The source code for the area that holds the column total with the closest searchable class name looks like:
<td class="ms-vb2"> <nobr> <b>Sum= 102,040,102</b> </nobr> </td>
<nobr> tags very rare in SharePoint sites? Could I do a search for all ms-vb2 and would I have a high chance of only finding one ms-vb2 with a
<nobr> tag in it? Any ways to finish off this idea or any better ideas would be great. Thanks in advance for any advice.