create pie chart in excel using different data

This will sort the data in the same order as the source data, which is in descending order by pie type within each category.

Categories in Reverse Order: Double click/right-click the vertical axis > Format Axis > Axis Options > check the box for Categories in reverse order.

Insert chart: Select the data > Insert tab > Bar Chart.

To recreate my Parts to a Whole Excel chart: Recreating the Parts to a Whole Bar Chart There are 4 series in the bar chart above and you can see them in columns D:G of my data table below: The key to this chart is all in the layout of your data. I could use 3 separate pie charts, or even a really bad pie chart like this:īut why would I when I can use a bar chart that’s quick and easy to interpret like this: Let’s say I want to see what the overall split is by Category, and then the breakdown within those Categories.

xlsx file please ensure your browser doesn't change the file extension on download. Excel for Customer Service Professionalsĭownload the Excel Workbook.

Create pie chart in excel using different data