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
Disney Event with Chris Menard in September 2022

Recent Microsoft Teams articles

Teams - Change your status in Teams | Duration and Status Message

Teams - Change your status in Teams | Duration and Status Message

Teams Online Couse - New material added

Teams Online Couse - New material added

Teams - LinkedIn Tab now Available in Teams Chat

Teams - LinkedIn Tab now Available in Teams Chat

Teams - 5 Tips for Recorded Meetings

Teams - 5 Tips for Recorded Meetings

Recent Microsoft Excel articles

Excel Status Bar - Tips Every User Should Know

Excel Status Bar - Tips Every User Should Know

How to SORT Data in Excel | 7 Tips

How to SORT Data in Excel | 7 Tips

Excel - Data from Picture - Microsoft 365 New Feature

Excel - Data from Picture - Microsoft 365 New Feature

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories