Step 1: How to add Total Values to Stacked Charts in Excel

Step 2: How to add Dynamic Series Labels (Excel Legend) for Improved Readability

Step 3: How to show Percentages in a Stacked Column Chart in addition to Values

Download the Workbook to follow along:

Free download SUMIFS, SUMPRODUCT workbook example

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.