This graph will demonstrate how to create a percentage graph in Excel and Google Sheets.
Make a Percentage Graph in Excel
The goal of this tutorial is show how to make a percentage graph based on different datasets.
Start with Data
We’ll start with data below.
Creating a Stacked Bar Graph
- Highlight the data
- Click Insert
- Select Graphs
- Click Stacked Bar Graph
Add Items Total
Create a SUM Formula for each of the items to understand the total for each.
Duplicate the table and create a percentage of total item for each using the formula below (Note: use $ to lock the column reference before copying + pasting the formula across the table). Each total percentage per item should equal 100%.
Add Data Labels on Graph
- Click on Graph
- Select the + Sign
- Check Data Labels
Change Labels to Percentage
Click on each individual data label and link it to the percentage in the table that was made.
Final Percentage Graph in Excel
The final graph shows how each of the items change percentage by quarter.
Make a Percentage Graph in Google Sheets
Copy the same data on Google Sheets
Creating a Graph
- Highlight table
- Select Insert
- Click Chart
If the X and Y Axis need to be swapped, check or uncheck Switch Rows/Columns
Change Chart Type
- Select Box under Chart Type
- Click Stacked Column Chart
Adding Data Labels
- Click on Customize
- Select Series
3. Check Data Labels
Double Click on each Data label and manually edit it to match the percentage (Can’t manually change this based on formula like you can in Excel)
Final Percentage Graph in Google Sheets