Excel Pie-Chart in categories

0 votes

In essence, the pie chart should show the data broken down by category or colour, with each entry represented proportionally to its value in relation to the others. The name and the percentage will be on data labels. Unfortunately, I was unable to organise the many entries by their category or colour in Excel, thus I was unable to make that work.
Please refer to the images below to see the outcome I'm aiming for with the given data.

[data

Chart to achieve

Oct 7, 2022 in Others by Kithuzzz
• 38,010 points
600 views

1 answer to this question.

0 votes

create a pivot pie chart. You can manually change the colour of each category. If they are not together, you can move the order around on the pivot table to make them so. Although that's not the finest approach, you can manage it.

image

answered Oct 8, 2022 by narikkadan
• 63,180 points

Related Questions In Others

0 votes
0 answers

Creating a chart in Excel that ignores #N/A or blank cells

A dynamic data series will be used ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,010 points
133 views
0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,180 points
412 views
0 votes
1 answer

Use R to create chart in Excel sheet

Here is a solution utilizing the XLConnect ...READ MORE

answered Nov 10, 2022 in Others by narikkadan
• 63,180 points
496 views
0 votes
1 answer

How to break area chart in excel

Add an extra row between your areas. READ MORE

answered Dec 17, 2022 in Others by narikkadan
• 63,180 points
141 views
0 votes
1 answer

Create a pie chart of ages, showing under 30's, 30-50's, and over 50's

Two things: A pie chart does not aggregate ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 63,180 points
1,188 views
0 votes
1 answer

Is there a reason why these bars wont line up in my excel chart?

STEPS Hover your mouse over any of the ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 63,180 points
235 views
0 votes
1 answer

Creating a stacked waterfall chart in tableau

You can try this as a solution: 1.) ...READ MORE

answered Apr 5, 2022 in Tableau by Vaani
• 7,020 points
896 views
0 votes
1 answer

How to modify Powerpoint Chart ChartData by Excel VBA

Example: Code: Set pptApp = GetObject(, "PowerPoint.Application") Set pptPres = ...READ MORE

answered Oct 16, 2022 in Others by narikkadan
• 63,180 points
1,887 views
0 votes
1 answer

Insert pie chart in Excel macro function

Think about arranging your data in a ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,180 points
786 views
0 votes
1 answer

Chart Name in Excel 2016

When you select the chart, it's now ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,180 points
172 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP