How To Add Charts To SharePoint Site

SharePoint site owners can easily add charts to their pages using different methods and tools. By following a step-by-step process, you can enhance your data visualization capabilities and unlock the full potential of your SharePoint site.

In this article, we will explore various options available for adding charts to your SharePoint site. Firstly, you can utilize the File Viewer Web Part, which allows you to embed an Excel document containing the desired chart onto a SharePoint page.

If you prefer creating a chart from list data in SharePoint Online, the Quick Chart Web Part is an excellent choice. With this tool, you can specify the chart type and data source, either manually or from a SharePoint list.

For more advanced reports and analysis, you can also consider embedding Power BI reports in your SharePoint site. This option provides in-depth insights and visualizations to effectively analyze your data.

Lastly, if you have charts or diagrams hosted elsewhere on the internet, you can utilize the Embed Code Web Part to point to them. However, please be aware that this method has limitations and may not accept all URLs.

Now, let’s dive into the detailed instructions for each method, allowing you to add charts seamlessly to your SharePoint site and enhance your data visualization experience.

Using the File Viewer Web Part

One option to add charts to SharePoint sites is by using the File Viewer Web Part, which allows you to embed an Excel document with a chart onto a SharePoint page. This method provides a convenient way to display your data visually and make it easily accessible to users.

To begin, follow these steps:

  1. Add the File Viewer Web Part to your SharePoint page by clicking on “Edit” and selecting the desired location for the web part.
  2. Click on the “Add a file” button within the File Viewer Web Part and upload the Excel document containing your chart.
  3. Once the document is uploaded, click on “Apply” to save your changes.

The File Viewer Web Part will then display the embedded Excel document, including your chart, on the SharePoint page. Users can interact with the chart and explore the data by clicking on it or using any available filtering options.

Example

“The File Viewer Web Part is a game-changer for our SharePoint site. We can now easily embed charts onto our pages, providing visual insights to our team members. It’s simple to use and has greatly enhanced our data visualization capabilities.”

– John Doe, SharePoint Administrator
Pros Cons
Easy to embed charts Restricted to Excel documents
Allows interaction with charts May require Excel skills to create charts
Enhances data visualization capabilities

Utilizing the Quick Chart Web Part and Embedding Power BI Reports

Apart from the File Viewer Web Part, SharePoint site owners have the option to utilize the Quick Chart Web Part to create charts from list data in SharePoint Online, as well as embed Power BI reports for more sophisticated reporting and analysis.

The Quick Chart Web Part is a powerful tool that allows you to easily create charts using data from your SharePoint lists. You can choose from a variety of chart types and specify the data source, whether it’s manually entered or sourced from a SharePoint list. This flexibility enables you to visualize your data in a way that best suits your needs. Whether you’re tracking sales figures, analyzing survey responses, or monitoring project progress, the Quick Chart Web Part is a valuable asset for data visualization in SharePoint Online.

For more advanced reporting and analysis, embedding Power BI reports is a recommended option. Power BI is a business analytics tool by Microsoft that allows you to create interactive reports and dashboards. With Power BI, you can connect to various data sources, transform and model your data, and generate insightful visualizations. By embedding Power BI reports into your SharePoint site, you can provide your users with a rich and interactive reporting experience, enabling them to explore and gain valuable insights from the data.

By utilizing the Quick Chart Web Part and embedding Power BI reports, you can unlock the full potential of your SharePoint site’s data visualization capabilities. Whether you need to create simple charts from list data or dive deeper into complex analysis with Power BI, these options empower you to effectively communicate and present your data to your audience.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.