how to make a pie chart in excel with your own data

It also works in 2016 for Mac, but not 2011. It will work in 2007/2010 but you will have to reassign the labels using a method mentioned in step 5 below. Warning: This file works best in Excel 2013 or 2016 for Windows. Download the Fileĭownload the example file to follow along.ĭynamic-Chart-Data-Labels-Stacked-Column.xlsx Download You can download the file to follow along or modify for your own use. In this article I will provide high level instructions on how to create this. Preferably Excel 2013 or 2016 for the “Value from Cells” label feature.Setting up the dynamic labels isn't too complex, but it does require a bit of labor. How to Create the Dynamic Chart Data Labels Of course you could put all these metrics in one label, but that typically leads to a very cluttered chart. The user can then quickly see the amount, percentage of total, or percentage change for each series in each bar. It allows the user to change the data label metrics with a slicer. So this chart attempts to help answer some of those questions. These are great questions that can help identify trends and the need to analyze the data further.

What is the percentage change from the prior period?.

What is the percentage of total for each series (segment) in the bar?.

What is the grand total amount for the bar (sum of the series)?.

🙂īut the stacked charts always seem to leave us with more questions… However, these types of charts are very popular and I am guilty of using them too. I have written before about how I am NOT a big fan of stacked charts, and shared some alternatives to the stacked bar or column chart.īasically, it's hard to make comparisons between the series in the bars because of the uneven baseline. Bottom line: Learn how to create this interactive chart where the data label metrics change based on a slicer.

How to make a pie chart in excel with your own data