how to make a pie chart in excel with two colloms

We need a cheat column that would keep a percent constant when filtered, so a helper column was in order. Pick a design if you would like (in this case, yellow for WSU). You can either go to the Home tab, Format as Table, or use the command Ctrl + T.Ģ. We learn about tables in Excel Essentials, and the advantages of formatting as tables in Excel Pivot Tables, so please come to a session if you are interested in learning more!ġ. new rows of data added), it was best to format as a table. Since data would be fluctuating in our case (e.g. This first step might be optional, depending on your use case. We originally started with source data (on the Source Data sheet in the document) that consisted of two columns: item and a number. In the document, one sheet is the source data, and the other sheet is the final chart with slicers that will adjust the pie chart accordingly.Ĭlick on a few slicer buttons to test it out. Here is the final document… and below will be the steps I took to create it: Example Document Rather than an exercise, I am going to try something different. What if we want to use those slicers, but also maintain the visual of the item’s percent of the grand total… in other words, in this case, to still show as 36% of the whole? Some finagling is in order. Looks great… but when I add my slicers and filter by one item, it always shows as 100% of the total, because it is 100% of what is displayed. Here is an example:īelow is a visual of a PivotChart Pie Chart… Normally when you select a slicer or filter a Pie chart by one item, each item shows as 100%.

Lastly, this is basically a different take on the idea of a progress pie chart… and I am by no means the creative genius behind this overall idea! If you have a minute, look at some of the tutorials out there for the different use cases for these.If you don’t, please come attend a session… times are listed in myTraining. Second, this article assumes you have some knowledge of Tables, PivotTables, and Charts in Excel.First, thank you to Marsha for having this question and inspiring this Byte!.Is it possible to create a PivotChart pie chart that can be filtered to show only the percent of the item selected? Here is one solution for that question (and spoiler alert, it is technically not a PivotChart). A fantastic question came up during last week’s open lab.

How to make a pie chart in excel with two colloms