Quick Chart based on count

Question

Is there a way to create a quick chart web part based on the number of alpha numerical values in a List in SharePoint online?

Answer 1

Dear Cadutch,

For real-time updating, you can keep the Excel file with the pivot chart, remove the gridline in it to make it look like a PDF file by clicking on View>uncheck Gridlines, upload the file to a site library, create a new page>insert the File Viewer web part, click on Edit web part>make the web part only show the pivot chart in the Excel file>save the page and now the page and the chart look like the following.

Now you can go to the site library>open the Excel file in the Excel application to update the source data and the pivot table and then the page will be updated as well after you refresh the site page.

Best Regards,

Cliff

Answer 2

Dear Cadutch,

Could you upload a screenshot of the list in your environment for our reference? You can upload the screenshot via clicking on Reply>Insert image.

Note: Remove any private information before uploading the screenshots.

Best Regards,

Cliff

Answer 3

Dear Cadutch,

Thanks for your updates.

Could you also upload a screenshot of the list in your environment for our reference?

Note: Remove any private information before uploading the screenshots.

Best Regards,

Cliff

Answer 4

Hi Cliff, 

To make sure I am understanding, it is not possible to count all the number of alpha values in a list and create a quick chart comparing all of those values ( ex. 4 of alpha value x, 5 of alpha value y). Could you compare the percentages of the counts to create a quick chart? For example of 21 values, you have 5/21 red, 4/21 blue, 7/21 green, 5/21 yellow

Answer 5

Dear Cadutch,

Regarding "Is there a way to create a quick chart web part based on the number of alpha numerical values in a List in SharePoint online? ", do you want to extract the number values from the string in Column1 in the following example list and use the extracted number to create a quick chart on a site page with a Quick Chart web part in SharePoint Online?

If yes, as the number extracted is got from a calculated column and the Quick Chart web part can't use the data from a calculated column mentioned here, the requirement may not be able to be achieved. You may need to create a new Number column and type the extracted values manually.

If something is misunderstood, welcome to give some screenshots and examples about the requirement in your environment for our clarification and we'll see if it can be possible.

Best Regards,

Cliff