pie

Hello All, I have a table which has conditional Formatting. The coloring is based upon formula. I have generated Pie Chart from it. I need the Pie chart sectors to have color that comes from the conditional formatting of the table. I'm using Excel 2010. Kindly suggest.

Hello, I would like to make a pie chart that contains a scale of 0 to 5. 0 begins in the middle of the circle and the outer circumference is 5. There would be roughly 100 pie pieces (Comments) that will individually be rated 0 to 5 (Score). My inputs would be as follows...

Hello, I have a cloumn with the following values (example) 221 315 565 865 55 323 221 9856 221 589 9744 655 221 As you can see 221 is repeated 4 times so i want the Pie chart to be created for all the values and higher percentage for the repeated value.. Hope it's easy to understand what I wrote.

Fellow sufferers! I just want to make a pie chart from arrays holding the values. Please see my code below, which loads the array review_statae into memory. I want to do something like below. I did lots of googling, never found the right way to do it. Public Function piechart_build(url As...

Hi, I am trying to delete the length of a word if multiple specific text is found in a cell, but the code I have deletes the whole string rather than just the length of the word which is variable, Can someone help. Dim c As range For Each c In Selection If InStr(c.value, "...

I have a 20-slice pie chart. How can reduce the saturation/intensity of the colors on the chart so that 1) they don't use as much toner, and 2) the black data labels inside the significant items are more legible.

I have a set of data. First column is date (first of the month), second column is a yes/no on whether or not something was returned. Is there a way to plot this as a pie or circle chart and format so that all the "yes" values are one color and all the "no" values are another (without changing...

Hi I have a table in Sheet 1 listing order items. I would like to convert the list to a single row for each order number. Sheet1 Order number Product Detail Qty 1 Poultry ****erel 10lb 1 1 Pies Pork Pie 4lb 1 1...

Hi, Is it possible to split hyphenated and delimited text into the next row but keep the data in the same rows? example From This <tbody> What Who When Why Apples Pie Something A1-A3,A5,A7-A10 Banana Split Nothing D1,D2,D8-D9 Candy Cane Everything B1,B3-B6 </tbody> To This...

Hi Is it possible to do that, for example let say I am allow to accumulate 40 hrs/week as a max. What I have accumulated now is 10 hrs. I want the pie chart to tell me that 30 hrs left. and if I add more hrs let say 5 more then the chat would say 25hrs left. Is that possible in pie chart? Thank you.

Good morning. It's my first time seeking help here. I have an Excel spreadsheet which has attendance reports for all employees working in the company. I want to create a pie chart which shows the percentage of good attendance, late arrivals, leaving early and absences per person each week and...

Hello! I'm using a donut pie chart in excel for the first time and I was wondering if there was any way to enter the total in the middle of it other than by manually using a text box. For example, if I have 20 on the left side of the pie chart and 30 on the right side of the pie chart, I want...

I would like to create a pie graph that shows the frequency of the number of times a customer has bought, e.g. how many bought 1 time, how many bought 2 times, etc. The raw information looks like this: The total orders is a calculated measure: Customer Total Orders =...

I'm setting up my budgeting spreadsheet. I want the pie chart to show how much I spend on each thing (food, bills, socialising etc). At the moment it shows each 'food' etc instance as a separate part of the pie chart rather than their collective cost. It also shows empty items on the key. How...

Trying to get 4 dining rooms with 4 tables set up to work in a pie chart I need a function that can move a client from 1 dining room to another and to a different seat.Can some one help with this pleaseÉ Also I have managed to get 1 pie chart working I saved in 4 different work books (clearly...

Hi, Is there a way to identify the lowest value in a pivot pie chart and highlight this in a set color? Would like this to change is the parameters of the pivot change as well. Thanks!

Hello, I have a drop down list that populates a table using a Vlookup. My table has a possible 10 rows. I need to be able to use the drop down and the pie chart reflects the table. The problem I have is that I have selected 10 rows but if the data only fills half then the pie chart...

Hello, I am trying to create an odometer chart which I've successfully done using one of several online posts on this topic (combining a doughnut and pie chart). However, I'd like two have two 'needles' on my chart. I've added a second pie graph to do this but the problem is, my needles won't...

Hi all, I have tables like this And i need to sum all rows for the Item 1, where status are Ready. Price and quantity is always different eaven for the same items, and somtimes the same items how more status, and i need to sum only ready items. Please help. This is for my work. Regards...

Hello!, I wanted to create a PIE chart that would be conditional on a drop down list. If the drop down list said "Febuary", then I would like the range of data that contains my income breakdown in the month of febuary. I tried to put this on the series of the Pie chart...