Adding Percentages Automatically with an Add-In
Unless your stacked chart is very small, the manual process will probably take a long time. Fortunately, kind people have created Excel Add-Ins to help automate the process. One of the best is made by AppsPro and it is called XY Chart Labeler. You can download it for FREE by clicking the link or the image below:
Run the installer to set it up. You may need to save your work, close Excel, and re-launch it for the app to appear.
You’ll know it is up and running when you see a new menu tab for XY Chart Labels when you select your stacked chart.
To add percentage labels to the stacked column chart, first select the chart. In the new XY Chart Labels menu tab, click Add Labels.
In the Add Labels dialog box that appears, choose the Data Series you would like to label (in the example, you can start with North). Click on the field under Select a Label Range. Click and drag to select the cells that hold the percentage values for the North data series in the percentage table we made. Click OK.
Repeat this process for each Data Series and your chart will have clean percentages on the stacked columns with a total volume at the top. This type of chart is so easy to read that you no longer need the Y-Axis labels!
Get the latest Excel tips and tricks by joining the newsletter!
Andrew Roberts has been solving business problems with Microsoft Excel for over a decade. Excel Tactics is dedicated to helping you master it.
Join the newsletter to stay on top of the latest articles. Sign up and you'll get a free guide with 10 time-saving keyboard shortcuts!