Powering the Quick Chart Web Part using a SharePoint List

As many people know, I am planning my wedding for next year. In a lot of scenarios in business, we need to be able to have a quick view of how money is being spent towards a specific goal or project. Without being an expert in data visualization tools such as Power Pivot in Excel or Power BI, you can take a set of simple data and use the Quick Chart web part within your SharePoint site to be able to tell the story.

Set up your list

First, you need to create your list within your SharePoint site. You need to have member or owner permissions within the site to be able to edit or create new items.

Create a new list

When you are considering the fields needed for the list, you must have at least one type of number column in order to use the Quick Chart web part later on. You can add the number column or also use a currency column to tell your story.

Create a number column in your list

Once you have added all of your columns, Fill in the list items to build out the content within your list.

List with data

Now that you have your list set up, navigate back to your page where you would like to place the chart.

Add and configure Quick Chart web part

Once you are on your page, be sure to put the page in edit mode and add the Quick Chart web part to the page.

Quick Chart web part

Select the edit icon on the left to open up the config panel for the web part.

Config

Configure your chart

Select which kind of chart you want to use

  • Column Chart – Better if you want to show percentages of a whole
  • Bar Chart – Better if you have more items in the list

Data:

Select “Get data from a list or library on this site

You can only choose a list or library that has a number column, so if you do not see your list in the dropdown, this is the most likely reason.

Select the column that has the data you want to display and the column in the list with the label that you want to use.

You can choose to sort the columns. In this case, I will sort by ascending order

Make sure to label your horizontal and vertical access so a user will understand the correlation.

Chart config panel

Once you are finished, remember to republish your page. Your chart is now available for everyone with permissions to view.

Final chart on page

Leave a Reply

Your email address will not be published.

Scroll to top
Close