how to make a pie chart in excel with totals

The background for this post was/is based on a simple report I build for a client. And, of course, the relationship and decision impact goes both ways. Those choices can be based on a variety of factors: are we producing a simple static report deliverable, is the workbook intended to be an interactive instrument, do people need to control slicers, timelines, and adjust input/output to create their own report results, etc.

When we work with data and charting, we need to decide how we setup our tables and which formulas to use for calculations. I’ll show you how to use it for this report, and for additional follow-up, definitely check out the excellent Microsoft Excel in-product documentation. Instead, Microsoft Excel has a function suited perfectly for the requirement: SUMPRODUCT.

You could create a formula at the end of every team-specific column to calculate the total of that column, but that’s inefficient and error prone…especially as you start to add new expense items and teams.

Setup Your Tableīelow is an example table which shows how taxable business expenses are spread across departments: That’s what will be demonstrated in this post, along with some use of basic features like Paste-with-Transpose and the SUM function. You can use the SUMPRODUCT function in Microsoft Excel to help you quickly calculate business expenses per department and then visualize that report data using Excel Pie Charts. Microsoft Excel – Expense Report with SUMPRODUCT and Simple Pie Charts Home › Business › Microsoft Excel – Expense Report with SUMPRODUCT and Simple Pie Charts

How to make a pie chart in excel with totals