pie chart help

I am trying to do a pie within pie chart. I have 5 data values. I really want the first 3 to show on the main pie chart and then break one of those 3 values out into the additional two data points in my list. How do I tell excel not to include these last 2 data points in the primary chart at...

I have created a pie chart which shows a segment for East-20%, West-50% & Central-30% and I want to show another pie splinting off from West showing the Cities which make up the 50%, A bit like pie of pie but instead of other like within pie of pie I want to just show the 3 regions within the...

Hi all, I have a question about data adjusting for a chart in excel. I have data that I want to chart which is tied to a data validation. Depending on the option selected a certain number of rows will display that I would like to chart. Is it possible to set it to ignore blank cells in the...

Hi guys, I was wondering if someone could steer me in the right direction? I was handed the below table at work and the boss basically wants me to calculate the sum of each response using a formula and then translate that data into a pie chart. Now at first I thought yeah this is basic, so I...

I need to create a pie chart which has 10 elements , say A-L. Amongst them A, B, C, D have 4-5 sub elements each. I would like to show A-L as a pic chart and then show the sub elements in A, B, C and D as well in a pie chart format. I want to show this as one chart.. IS it possible to do this...

Hello! I am trying to get my pie chart to show the actual values and the % to total for each 'slice'... Is there any easy way to display both of these metrics? Thanks!

Hi Guys I need to change the slice colours in around 200 pie charts as quickly as possible. I dont want to right click on each slice in each individual slice and format the data point. Is there a quick way of doing it that anyone knows of? Thanks in advance Stephen