Jump to Create an elaborate doughnut chart - The following procedure will help you create a doughnut chart with similar results. For this chart, we. The Doughnut Chart is a built-in chart type in Excel. Doughnut charts are meant to express a 'part-to-whole' relationship, where all pieces together represent 100%. Doughnut charts work best to display data with a small number of categories (2-5).
Here is an issue that has been bugging me for several months now. I have a table of data to which I applied conditional formatting color scales: the cell fill color transitions from blue to yellow to red as the values in the table go from lowest to highest. The table has 36 columns in it and 10 rows. I want to plot the data in a donut chart with 36 'slices' in 10 concentric circles. (The top row of the table would be the center of the donut and the bottom row would be the outermost donut.
0 would be the top of the circle, 90 would be @ 3 o'clock, 180 at the bottom, and so on.) All the slices need to be the same width, as shown, but ultimately I want the colors of the donut chart to match the color scale of the table. I'd also like to be able to view the values for each cell, even if that is in a separate view/version of the donut chart.
I'm currently stuck trying to determine the RGB color code of each of the cells in the table. I've read through the VB functions explained at and none of that appears to be what I need. Any assistance at all would be greatly appreciated! I would like to copy a small table from Word into one cell in an Excel worksheet.
The first column of the table is a list of numbers. I tried converting the table into text with manual line breaks and tab stops to divide columns and rows, but that didn't solve my problem. Excel pastes the data into several rows. When I try to merge them, I get a warning that the selection contains multiple data values, and merging into one cell keeps the upper-left most data only. What I tried that didn't work:. Formatting the Excel cells as text before pasting the data. The various options for 'Paste Special.'
The closest I got was inserting the table as a Document Object, which could be a workaround, I guess. What I am saving for when all else fails:. The obvious solution of copying row by row into one Excel cell. The data in the table is information about my dad's medications. I would like to have reference charts of how to identify the strength of each tablet by its color and markings.
I got the info from the manufacturers' websites and entered it into tables in Word, which I would like to copy into a more comprehensive file I am creating in Excel. The first column of each table is the strength of the tablet, entered as 1 mg., 2 mg., etc. The subsequent columns describe the shape, color, and markings. There are 3 tables, each with about 4-5 rows. Is there a way to copy each one - whether as a table or as text - into a single Excel cell without losing data? How do I get the colors to change automatically when I use a drop down list. Per say here is what I am trying to do If a certain 'word' is used from the drop down list I want the background of that cell to change its color to 'green.'
And if later I change the 'word' to another from the drop down list, it will change it's color to a specified color. The drop down list that I use was created from cells that have the colors already in the 'word', but I do not know how to make the list show the colors so it puts the word & color automatically in the drop down list to the cell with the drop down (if that makes any sense).
If there is a way, please spell it out simple enough for me to understand, as I don't know fully the capabilities of formulas or vba. I'm trying to use conditional formatting to highlight phone calls that came in between certain hours. The call times are in the custom format h:mm, although it could easily be changed to an Excel time format. I'm using Excel 2002. I want the cell to have a different fill color if it falls within particular time frames.
Example: If the call came in between 22:00 and 23:59 color is light green. If the call came in between 23:59 and 08:00 the color is yellow. Example spreadsheet is attached. Thanks in advance. I have cells in a column, some colored yellow, some not.
I am trying to use the SUMIF function to sum only the cells in the range that are colored. Can this be done?
Can I enter something in the 'criteria' part of the formula that can do this? =SUMIF(D3:D13,'criteria',D3:D13) I also tried to use the CELL function's color feature, but I couldn't get it to work right. I don't know how to get Excel to recognize if a cell is colored in a formula.
=CELL('color',cell) It might just be that I don't know what this means in Help: 'color' - 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero). Can anyone help? Regarding Charts in Excel: Is there a way to have the Min and Max values adjusted dynamically for the Scale of the values being displayed?? I know that I can use named ranges to display various sections of data - month by month, or quarter by quarter, for example.
But when the value of these ranges vary greatly from section to section I end of having to manually go and adjust the Min and Max values of the chart scale. For example, if I was looking at a graph of the S&P 500's prices last November, a Min and Max range of 750 to 1200 would be fine.
![Download Download](/uploads/1/2/5/5/125505073/791863812.jpg)
But if I had a dynamic range established and scrolled over to view the S&P 500's prices for this past February, I would need a Min and Max range of around 650 to 850. Is there a way to have these Min & Max values adjust automatically depending on the values being displayed?? Thanks StanSz. Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet. I am running Excel 2011 for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data.
I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions. Hey there, I have been tasked with introducing userforms into an excel sheet and tbh I'm quite amazed that excel has this capability of adding userforms to excel sheets.
Anyway, I have 2 columns of data in an excel sheet and I wish to add this to a userform so that the userform displays the 2 columns beside each other with headings, like a table. The user should then be able to select a particular row and insert it into the specified cell. I would also like the user to select a row on the table and then be able to bring up another table depending on the row selected.basically so that the user can draw deeper into the information that they require. I have an example excel sheet where I have 2 sheets. One sheet is the user entry sheet called User Entry Screen.
The next sheet is the tables sheet where my tables are held. Once the user selects the cell shown in the example sheet, it should then bring up the user form. The user then, depending on which item clicked, then gets shown the next window with a table and info on it. Then user should then be able to select an item and the cells on the user entry screen would then get populated.
Personally I think this is a really tricky challenge and any help with doing this would be extremely appreciated. I'll post up further comments as I am trying to work my way through it!
Hello, what I would like to do is take a portion of a sheet. So the cells I want to mirror are in the proposal sheet cells B32 x F51. And then mirror the exact duplicate copy to another sheet. The other sheet should have those same values at A20 X G39. What I am trying to do is have a sheet that has skus, prices, and so forth and then when I add,delete, merge, color, or do anything to the cell on the 'proposal creation' sheet I want it to mirror only a specific cells to another sheet that is 'salesman copy' that we will print to clients.
So this way ont he proposal copy a salesman can insert rows or even change the color of the cells and then have it mirror exactly the same on the 'salesman copy' which is what we will print for clients. Hi everyone, I found an excellent macro this morning that allows the user to filter a pivot table based on the value found in a specific cell.
This cell essentially acts as a search bar, allowing the user to type in what they are looking for rather than select it from a drop-down list. The macro works perfectly for my purposes except in one regard: I can no longer perform a 'show all' filter. If I leave the 'search bar' cell blank, the pivot table shows nothing.
![How Do I Make A Doughnut Chart In Excel 2011 For Mac? How Do I Make A Doughnut Chart In Excel 2011 For Mac?](/uploads/1/2/5/5/125505073/379858519.jpg)
I'm sure that there is an easy fix for this but I'm still learning the basics of how to write and use macros. How can I change the code so that when I leave the cell blank, the pivot table shows all? The search bar cell is D2.
Thanks for your time! Hey everyone, I'm really hoping someone can help me with this. I need to plot percentages over time in a line graph in excel. I don't want to have to do a percentage equation in the spreadsheet, I just want excel to take two sets of values and display the percentage in the chart. For example, I need B1 as a percentage of B2 for week 1, C1 as a percentage of C2 for week 2, etc. Can someone please offer a suggestion for how to do this? I would really appreciate it.
Also, would it be possible to link data from other sheets in the workbook into one single chart?