How to Make a Percentage Chart in Google Sheets (3 Ways)

There is a wide range of visualization tools accessible in Google Sheets. You can visualize data using these tools and understand how various data components work together as a whole. The percentage is one type of data element. You may learn how to make a percentage chart in Google Sheets by reading this article.


A Sample of Practice Spreadsheet

You can copy the spreadsheet that we’ve used to prepare this article.


3 Ways to Make a Percentage Chart in Google Sheets

Simply defined, there are five different types of charts that may be created to display the percentage of data. The data criteria and data form mostly determine the structure of the data.

Additionally, we will show you how to edit each graph section by section. Check out the examples in the next part to have a better understanding of the concept.

1. Inserting Bar Chart

A graph with rectangular bars is called a bar chart. Typically, the graph compares various categories. There are three types of bar charts to present the percentage data.

1.1 Horizontal Bar Chart

Horizontal bar charts are those in which the grouped data are displayed horizontally in a chart with the aid of bars.

Suppose we have information on the most popular fruits in the USA. The vote is represented as a percentage. To create the bar chart, we will use the following data. Check out the instructions below.

data for how to make a percentage chart in google sheets

Steps:

  • We must once more choose the data range, which is B4:C10.

how to select range in google sheets

  • Then select Insert > Chart.

how to navigate to the chart option in google sheets

  • Depending on the data, Google Sheets automatically suggested a horizontal bar chart.

bar chart in google sheets

  • However, we’d like to change the automatically generated title for the chart, which says “Popularity vs. Fruits“.
  • To alter the title, use the Customise tab > Chart and axis titles option.

chart editor option in google sheets

  • By using the down arrow from the Title type selector, we need to change the “Horizontal axis title” to the “Chart title.”
  • We shall put “Popular Fruits of USA” in the Title text.
  • The Title font size box allows you to choose the title font size from Auto to 20.
  • Select B under the Title format box to make the title bold.
  • Consider that instead of Auto, the title text color will be Blue.

how to customise charts in google sheets

Finally, we will have the following bar chart with the title “Popular Fruits of USA” in bold and blue color, showing the percentages on the X-axis and the names of the fruits on the Y-axis. Using the same process, you can change the names of other titles.

how to make bar chart using percentage data in google sheets

Read More: How to Use TO_PERCENT Function in Google Sheets


1.2 Column Chart/Vertical Bar Chart

Vertical bar charts are graphs or charts that use bars to display grouped data vertically in a chart or graph, with the bars serving as a measure of the data.
Take into account that we will once again create a column chart using the data of the most popular fruits in the USA. Check the steps below.

percentage data for column chart

Steps:

  • We will first choose the data range. It’s B4:C10 in this instance.

selection of range in google sheets

  • Navigate to the Chart option using the Insert menu on the toolbar in the second step.

how to change chart

  • In the spreadsheet, we will discover two things. A Chart and a Chart Editor.
Tip: The chart is movable wherever you want it. The feature is quite adaptable thanks to Google Sheets.

use of toolbar to access chart in google sheets

  • Check the chart Setup now from the Chart editor. Depending on the dataset, it opened a Bar chart by default.
  • We’ll choose the leftmost down arrow. There will be a list of Chart types in a drop-down menu that appears.
  • At the bottom, choose the Column chart.

where to find column chart in chart editor

  • We shall discover the column chart presented in the picture below.

column chart using percentage data

  • The Customise tab in the Chart editor allows us to modify the chart as we see fit.
  • A list of customization options will appear if we select the Customise tab.

features of customise tab of column chart

  • Consider that we will modify the Chart style.
  • When we select the Chart style, six viable options will appear.

chart style

  • For our experiment, we’ll only use a few options. The background color will now be Light Gray 2 instead of White.
  • Instead of having no border, we will make it blue.
  • Finally, we will select “” the 3D option to improve the data visualization.

how to change chart style in google sheets

By the time we’re done, we’ll have a column chart like the one you can see below. The Y axis of the column chart displays the percentage number, and the X axis lists the names of popular fruits.

column chart using percentage data in google sheets

Read More: Google Sheets Calculated Field Percentage of Total in Pivot Table


1.3 Stacked Bar Chart

The stacked bar graph separates the data into many groups. This style of bar graph allows for the representation of each component using a different color, making it easier to distinguish between the many categories.

stacked bar chart data

Consider that we already have information on the monthly expenses of a student. To display the data graphically, we will utilize a 100% stacked bar chart.

Steps:

  • In the beginning, we must choose the data range. In this case, it is B4:E10.
  • Then select Insert > Chart.
  • The spreadsheet will by default display a column chart with a Chart editor.

chart editor in google sheets with chart and data

  • Choose the 100% stacked bar chart from the Chart type drop-down menu in the Bar section.

where to find 100% stacked bar chart

  • This stacked bar chart will then appear after the chart has been updated.
  • In the series, we intended to display the data labels, i.e., Transportation, Food, and Education.

stacked bar chart in google sheets

  • Select the Series section under the Customise tab. There will be a drop-down window with some features.

how to customise series in chart editor

  • To display the data on the chart, we will check “” the Data labels.
  • When we select the Data labels, a new segment for customization will appear.

features of data labels in chart editor of google sheets

  • We’ll move the labels from the Auto to the Centre position.
  • To make the data bold and italic in form, we will select both options on the data label format.

modifying data labels in chart editor of google sheets

  • After that, a stacked bar chart with data labels is what we find.

making of stacked bar chart in google sheets using percentage data

As you can see, the chart outlines the monthly costs associated with each condition. For instance, the cost of education in February and May is unquestionably greater than 25% of overall expenses, although it is less than 25% in most other months.

Read More: How to Calculate Percentage in Google Sheets (4 Ideal Examples)


2. Applying Pie Chart

A pie chart is a form of a chart that represents data in a circular graph. The most common way to display percentage data is on a pie chart.

Let’s say we have information on the current budget of a sports club. We must outline the intended use of the fund as well as the total expenses.

data for pie chart

Steps:

  • First, we need to select the data range B4:D11.
  • Select Insert > Chart after that.
  • Depending on the data, Google Sheets will automatically create a column chart, and we can find the Chart editor right next to it.

google sheets automatic chart creation

  • However, using the chart editor, we will make a pie chart., for instance. Check the Pie Chart option under Chart Editor > Setup > Chart Type.

where to find pic chart in google sheets chart editor

  • The column chart will be gone, and the following pie chart will appear in its place.

pie chart with data

  • We’ll use the Customise tab to make it more attractive and representative.
  • We will have the following 5 options for the pie chart under the Customise column.

customise features of pie charts

  • By selecting the Pie chart option, we will begin customizing. When we click it, it expands and presents us with the following choice.

pie chart customise drop down menu

  • We’re going to switch the Slice label from None to Percentage.
  • Consider using 14 as the Label font size rather than None.
  • When choosing a Label format, we’ll use both bold and italics.

how to change slice label in pie chart

  • We will choose the Net as the slice option in the next section of the Pie slice.
  • Set the distance from the centre to 25%.

how to create distance from center in pie slice

  • We will now alter the Chart Title under the section titled “Chart and axis titles“.
  • You will notice that the old title was Cost and Percentage if you look very carefully. By choosing the Chart title first, we will make changes to it.
  • We shall type Sports Club Budget in the Title text.
  • For the Title format, don’t forget to click the B to make the text bold.

how to change title in pie chart

  • After customization, we will have the pie chart below.

To summarize, we utilize the pie chart to update the labels, the pie slice to accentuate variation in the chart by moving the net slice 25% out from the centre, and the chart and axis title to create a more meaningful title for the chart.

Pie chart with percentage data in google sheets

We can now clearly understand their intended use for the fund. For instance, their budget for purchasing a chess board is the lowest at 10% of the overall budget. A tennis table will be purchased with the majority of the money, which accounts for 30% of the whole budget. In Google Sheets, people typically use pic chart to make percentage data visually representable.

Read More: How to Change Pie Chart Percentage to Number in Google Sheets


3. Using Pareto chart

A Pareto chart is a statistical chart that combines line and column charts. Google Sheets does not come with a Pareto chart by default, but we can add one by using the Combo chart.

data for pareto chart

Charts like the Pareto chart are frequently used in engineering and scientific works to explain relationships and findings. Consider, for instance, that we have data on precipitation that will be used to generate a precipitation hydrograph to display the increasing level of precipitation by the hour.

Steps:

  • Choosing the B4:E11 range is necessary once again.
  • Then, using the Insert menu in the toolbar, navigate the Chart once again.
  • As you can see in the following image, Google Sheets created a Combo chart based on the data.

combo chart in google sheets

As a result, the Pareto chart will display the amount of precipitation as blue column bars. The line graphs, where the red line indicates the cumulative frequency and the orange line represents the cumulative percent, demonstrate the rise in precipitation level by the hour.

combo chart using percentage data in google sheets

Therefore, if it seems essential, you may also make a combo chart in Google Sheets utilizing percentage data.

Read More: How to Calculate Percentage Increase in Google Sheets (4 Ways)


Final Words

You can make whatever chart you want using percentage data. Therefore, it is a good idea to familiarize yourself with all the charts that Google Sheets provides. In this article, we attempted to demonstrate how to create a percentage chart using Google Sheets. Hope that was most helpful to you. Please leave a comment if you have any questions. Check out OfficeWheel for more useful articles.


Related Articles

Ishrak Khan

Ishrak Khan

Ishrak Khan is a writer and urban planner born in Dhaka, Bangladesh, one of the largest mega-cities. He is a professional Content Developer closely working with OfficeWheel. He simply likes to enthrall his readers. He loves Football, Nico Robin, Deserts, and Twix. If you like the post, give him a heart on Instagram.

We will be happy to hear your thoughts

Leave a reply

OfficeWheel
Logo