Right-click on one section of the secondary chart, click Format Data Point…, click Fill, then click No Fill from the color drop down. To do this easily, enter data into Excel but combine the desired numerical values into a single row and name the categorical value “other.”Įnter data into Excel with the desired numerical values at the end of the list.ĭouble-click the primary chart to open the Format Data Series window.Ĭlick Options and adjust the value for Second plot contains the last to match the number of categories you want in the “other” category. There are two ways to combine a number of small categories into one “other” category.
#HOW DO YOU MAKE A PIE CHART IN EXCEL UPDATE#
smallest to largest), sort the original data using Excel’s sorting tool, and the chart will automatically update group the chart slices by size.Ĭombining Small Slices into an “Other” Category If you want to position the slices based on size (e.g. You can create new categories, sort how the slices appear, and add WordArt. There are a variety of ways to customize a pie chart.
#HOW DO YOU MAKE A PIE CHART IN EXCEL HOW TO#
Secure request management Streamline requests, process ticketing, and more. Learn how to create Pie Charts, Pie-in-Pie Charts, Doughnut Charts, and Pivot Pie Charts in this step-by-step tutorial video.Process management at scale Deliver consistent projects and processes at scale.Content management Organize, manage, and review content production.Workflow automation Quickly automate repetitive tasks and processes. How to Make a Pie Chart in Excel 150,456 views 1.6K Dislike Share Kevin Stratvert 1.52M subscribers Learn how to create Pie Charts, Pie-in-Pie Charts, Doughnut Charts, and Pivot Pie.Team collaboration Connect everyone on one collaborative platform.Smartsheet platform Learn how the Smartsheet platform for dynamic work offers a robust set of capabilities to empower everyone to manage projects, automate workflows, and rapidly build solutions at scale.