📊 How to create Charts in Microsoft SharePoint Lists

In this video you'll learn how to transform a normal SharePoint list in a cool Chart.
I'll drive you in every step to implement an existing open-source solution that leverages the capabilities of list views & columns formatting to bring amazing Charts to life on SharePoint pages.
🔗 Open-Source Project Website
adoption.microsoft.com/en-us/...
🔗 GitHub Project
github.com/pnp/List-Formattin...
👇
🔔Don't forget to subscribe to my channel to stay tuned Subscribe: kzbin.info...
👆
📺 REQUEST VIDEOS THAT YOU'D LIKE TO SEE
forms.office.com/r/NjTNvfaY13
🎬More Videos:
-Microsoft Teams: • Microsoft Teams
-Microsoft SharePoint: • Microsoft SharePoint
-Microsoft 365: • Microsoft 365
-Azure: • Microsoft Azure
-PowerPoint: • Microsoft PowerPoint
-⚙Tools: • ⚙Tools
-Shorts: • Playlist
📺My KZbin Channel:
/ giulianodeluca
🔗Let’s connect on social:
/ delucagiulian
/ delucagiuliano
/ delucagiulian
/ delucagiulian
/ delucagiulian
delucagiuliano.com
⏲Timestamps
00:00 Introduction
00:23 Demo Charts in SharePoint List Views
02:53 Displaying a chart with read permission
03:47 Open-Source Project
07:45 Starting from scratch implementing a chart
08:36 Creating a list reusing the Excel file
10:05 Double check on the list imported
11:00 Creating the list view Stacked Bars Chart
12:50 Applying the JSON to turn the list view in a chart
13:39 Using the list web part to include multiple charts in a page
14:39 Conclusion
#GiulianoDeLuca #DeLuca

[@AACLAGE]

It was a lot of content and great work from the creator of the formatting.

[@user-go9iu3in9r]

Super handy and easy, thanks!

[@DeLucaGiulian]

Thanks 😉

[@meenakshirajendrakumar8724]

how did you create the chart view in the list .. I am not getting that view option to switch from All Documents please explain ...

[@myandrobox3427]

Great efforts by the creator! ❤👏👏Very handy and i really like it. Thanka for sharing this!! Just that, it has its limitations like number of bars can't be more and works good for static data, we cant have data updates automatically and expect the charts to be refreshed. But, must say, great work by creator, atleast we can have something visual from the SharePoint lists, this must be basic actually developed by Microsoft already.

[@DeLucaGiulian]

Thanks for sharing your feedback

[@stephanedenis5394]

Thanks, very impressive, all in JSON without going through PowerBI to get graphics.

[@DeLucaGiulian]

Glad I could help!

[@decootubization]

Wow that’s clever!

[@DeLucaGiulian]

Thanks

[@p_M5]

Great video... very creative I must say. just wanted to check if the list get refreshed with new data, does the charts also get refreshed?. Many thanks..

[@DeLucaGiulian]

Hi, Thanks for watching, yes the chart gets refreshed.

[@p_M5]

@@DeLucaGiulian Thanks for the quick response. Your page have very good content.I have a small request if you dont mind. It would be great if you can create a video on your journey to become an MVP, how you achieved it and any advises for any apsiring MVPs here. Thanks

[@DeLucaGiulian]

Thanks very nice tip I'm going to do that

[@ruigoncalves6285]

I see the option for editing the values manually on the list page but can this be autopopulated by pulling in data from a previous list or query?

[@DeLucaGiulian]

Hi, The inline editing function update immediately the value of the field in the list, you can't pullout previous values. Eventually you can use the version history function to restore previous values in the list.

[@kamozzi1]

Thank you for the video and valuable content. I'm interested in exploring the opportunity to generate charts for SharePoint usage, activity, and file storage using JSON. Could you please provide guidance on how to proceed? Your advice is appreciated.

[@DeLucaGiulian]

Hi, Many thanks for following my videos. Check this article which explains where to read all these info learn.microsoft.com/en-us/microsoft-365/admin/activity-reports/sharepoint-site-usage-ww?view=o365-worldwide

[@danyell12345]

Is there any way to make a chart with rows form a list vs. columns like in this example? This example looks like it is just one row w. multiple columns. I'd like to do one chart for multiple rows. right now, when applying this json, you get a chart for every row.

[@DeLucaGiulian]

Hi, Just add a new row with different values for instance and you should see another chart showing up

[@MrAkerblom]

I have the same need as @danyell12345. It's not another chart that is of use here. It is to make each row a new bar in the one chart. Hence the code mustgo from field to row. But I guess that is at pretty different code? :) @@DeLucaGiulian

[@MrAkerblom]

Great material :) Does anyone know if it's possible to make a horizontal bar chart?

[@DeLucaGiulian]

Hi, Yes, you can have a look here: github.com/pnp/List-Formatting/tree/master/view-samples/custom-charts

[@MrAkerblom]

Oh sorry missed that! My goal is to make roadmap-view based on a horizontal stacked bar chart. This requires that the bars/timeslots is based on a new row and not by column. But if I add a second row I get a second bar chart. Any idea on how this could be managed? @DeLucaGiulian

[@DeLucaGiulian]

It works already in this way, if you add a second row you'll get a second corresponding chart

[@dylanmm007]

Is there any way to stop viewers of the charts from editing the values in the charts?

[@DeLucaGiulian]

Hi, Viewers with only read permission can't edit values, if they can, it means they have write permission on the list.

[@kdavidwhite8376]

My "All Items" on my list page doesn't have the chart or pie view listed

[@DeLucaGiulian]

Hi you can change the default view with yours view