How To Show Percentages In Stacked Column Chart In Excel

Posted on:  11/21/2021
How To Show Percentages In Stacked Column Chart In Excel

With a stacked column chart in Excel, you can view partial numbers, but what do you do when you want to show percentages? Excel's pie charts show percentages, but stacked column charts do not. We are going to use a mixed reference to create a column chart with percentages.

Stacked column chart with percentages in Excel

Stacked column chart with percentages in Excel

YouTube vdeo

Other Excel articles

Steps to create a stacked column chart with percentages

  1. Copy your data and paste somewhere else on your spreadsheet 3:26 in the video
  2. Select and remove the values and use a mixed reference to find the percentages 3:53 in the video
  3. Create a stacked column chart - 5:00 in the video

Recent Microsoft Teams articles

Microsoft Teams - Swap Meeting to Mobile Device | Transfer to this device feature

Microsoft Teams - Swap Meeting to Mobile Device | Transfer to this device feature

Teams -  Reply To Chats - New Feature October 2021

Teams - Reply To Chats - New Feature October 2021

Teams  - Why can't I record? Video call vs. meeting

Teams - Why can't I record? Video call vs. meeting

Teams: Live transcription in Teams meeting - 2021 New Feature!

Teams: Live transcription in Teams meeting - 2021 New Feature!

Recent Microsoft Excel articles

Excel - Create a custom list to sort data

Excel - Create a custom list to sort data

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

How To Show Percentages In Stacked Column Chart In Excel

How To Show Percentages In Stacked Column Chart In Excel

Subtotal Command in Excel - automatically calculate subtotals and grand totals

Subtotal Command in Excel - automatically calculate subtotals and grand totals

Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories