pie

Hi, I'm producing a pie chart in excel (2016), and each line in the data series is colour coded. I'm trying (unsuccessfully) to get excel to use the colours for each line in the data series for the corresponding pie slice in the chart, but it just uses its own default colours. Can anybody...

Hello I have been asked to create a bubble chart but I need to have each bubble dislaying 2 pie pieces (for example one bubble that has a "pie piece" to represent 10% of the bubble. Does anyone know if this is possible? Thank you for your help

Hi there - I'm trying to create a pie chart that will only have two sections: the sum of the top 5 values, and the sum of all of the other values in the column. For example: Let's say I have a list of 15 cars - one part of the pie chart will be the sum of the 5 most expensive cars. The other...

I'm trying to figure out how to make a pie chart dynamically adjust both in terms of the data labels and the percentages, and not having much success so far. I found this video (https://www.youtube.com/watch?v=T8P8xMBkH4I) which seems to get close to the idea, but I'm finding that my need...

Hi all, Having done a similar VBA code before I have tried to do this myself but I am struggling. On sheet two I have a drop-down box that I inserted via the form controls (developer tab). The drop-down box has been linked to cell c17 in sheet one. Cell c17 in sheet one forms part of a range...

i have a pie chart, where in the ''data labels'' i have activated the below: How do i set it, so the value in the pie chart has no decimal digits? (the table that provides the values in the pie chart has values with decimals, and would not like to change it)

hi al, how to create a Pie chart with % and original value sample: Fruit Items % Banana 15 =(15/53) Apple 21 =(21/53) Orange 17 =(17/53) Total 53 Any Advice? Thanks

Morning all I have the above issue when i filter on the source data How do i set the pie chart so that the original colour always stay the same? I have a area graph displaying the same data above it and that works fine Thanks

Hey Guys, I thought this would be easier since its a logical process. I am wanting to make the rows the same color as the data on the pie chart. These are very simple pie charts and each row has a slice of the pie. Is there an easy way to make the pie chart colors auto match the rows on the...

The boss wants an icon in each data label of a 6-slice pie chart. I can insert the image into the label but it often covers the text and value. Can I create a label for text/value and a second for the image? I can't put any of these values into the pie slice because some of the slices are quite...

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...

Hi everybody, I have a sheet with Jan to Dec in column a, and then data in eleven columns c-m Below this, I have two pie charts, one for the current month, and one for the year to date. How do I get the current month to update and use the current month's data? Thanks in advance Jo Win 7 &...

Hi I'm trying to create a gradual colour wheel in a pie chart style which starts from dark red at 12 o'clock, gradually changes clockwise to yellow and then to green to complete the wheel. I've tried an autoshape but this doesn't generate the gradual colours in the way I'm looking for. I've...

Hello everyone, I'm kinda stuck here, I have some problems, after some calculations I need pie to change color form blue to red IF 1 of 2 (or both) cell's values are greater then 0.2%. Does any1 have any idea how can I achieve that? I can attach excel file if it's needed. Best regards!

Hi all, Hope your Friday is going well. I am currently working on a dashboard for KPI's and i have been making some pie charts. I have displayed the pie charts percentage on each section of the pie and I was wondering if there is a way to hide the zero percentages. Thank you in advance, Mark :)

I'm trying to make a pie chart show one segment under one condition and then four segments under another condition. So basically, I want the set of data to change from just one value to four values. I tried using OFFSET to define a range that would change its dimensions, but Excel doesn't like...

I'm merging Excel data to either Word or Publisher to create a set of reports. Each report includes a pie chart. I'm trying to avoid copy/paste. Can the already created chart be merged to the report? Can the data be merged to the report and auto create the chart? I think I've seen it done with...

Hello all, I am in need of some creative ideas for the following task: I need to compare hundreds of products to each other to find products that are similar/dis-similar based on the ingredients in their recipes. See below example products to illustrate my idea. In this product set I need some...

I'm building a spreadsheet of demographic results. I'm wanting to convert many of the rows of data into pie charts for easy consumption. My first attempt is trying to convert my Age row of data into a pie chart. Here is a sample of made-up data... <tbody> Person Identifier 1 2 3 4 5...

Hi I created pivot table like this <tbody> dept salary sales 10 admin 20 hr 30 </tbody> Then I inserted pivot chart - Pie chart. everything is fine so far. Now when I insert City as a column in the pivot table (see below) then the Pie chat wont work anymore. How can I fix the pivot...