Look Who it Was Random video

Excel - Excel Tutorial: Create a Pie Chart by Department with SUMIF Function - Episode 641

556 views · Published 26 March 2009 · 2:42 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Create a Pie Chart by Department with SUMIF Function.

Welcome back to another MrExcel netcast! In today's episode, we have a question from Patrick about conditionally summing data in Excel. Patrick keeps track of his time spent each day and wants to build a pie chart at the end of the month to show how much time he spent helping other departments, while ignoring internal time. Currently, he is manually adding up the data, but we can use a simple formula to make this process much easier.

First, we need to create a list of all the departments that may appear in the pie chart. This can be done in a blank section of the spreadsheet. Then, we can use the SUMIF function to add up the corresponding values from column B for each department. By using the entire column for the range and referencing the department in G4, we can easily copy the formula down and have it work for all departments.

Once we have the data set up on the right-hand side, we can easily create a pie chart to visualize the data. Instead of showing percentages, I recommend changing the chart options to display the category name (department) and the value (hours spent). This gives a more meaningful representation of the data, rather than just a percentage.

To make the pie chart more visually appealing, we can also customize the colors. Simply select the whole pie, then click on a specific wedge and right-click to access the "Format Data Point" option. From there, we can choose a different color to make the chart more vibrant and eye-catching.

Thank you for tuning in to this netcast from MrExcel. I hope this tip helps you with your data analysis and visualization in Excel. Don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Patrick asks how he can summarize his monthly time sheet to create a pie chart by department. Using the SUMIF function provides the step to make this relatively easy. Episode 641 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Table of Contents:
(00:00) Introduction to the question from Patrick
(00:22) Setting up a time sheet in Excel
(00:32) Building a pie chart to track time spent on different departments
(00:42) Using the SUMIF function to automate the process
(01:30) Creating a pie chart and customizing it with data labels and colors
(02:22) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Data labels
Default colors
Department abbreviation
Excel spreadsheet
Format Data Point
Pie chart
SUMIF function
Time sheet
Time tracking
Value labels
Vibrant colors


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152281/

More from this channel