pie chart

Hi there, I've just created a mock voting system, and added a pie chart to show the percentage vote. However, to emphasise the winner of the vote, I want to automatically explode out the piece that wins. Is there any way that I can do this and have it automatically update when the data...

Hi everyone, I'm really struggling with how to show some information on excel. I'm trying to create a very simple dashboard that shows a pie chart for incoming calls received by each customer service employee. And another for outgoing and then a total. I would like a bar chart next to it that...

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!

I would like to create a pie chart that is surrounded by a doughnut chart--basically to display two related data streams of the intake and resulting output. Is this possible using excel graphing functions only, or is Visual Basic needed? I can sort of get what I need by creating two separate...

I'm rather new to Excel VBA and to be totally honest, the object model throws me a bit. So any help that you are able to give would be greatly appreciated. My environment: Win7 and Win8, Excel 2007, Excel 2010 I use a program called Advent Axys that embeds a chart within a frame in their...

Hello, I have some 3D Pie Charts based on Pivot Tables. They work just fine. I would like to move the larger part of the Pie Chart to the top leaving the smaller slices on the bottom and the ablility to read the percentage and title. Please advise if you have a solution - thanks for your...

I want them to fill in percentages in column B that must = 100%. Then I want them to color code each cell where they entered a value with either red, yellow, or green. I want the pie chart wedge colors to match the source cell rather than the colors Excel is automatically assigning. I...

Here's my challenge: I have 100 sheets in my workbook that are all identical in layout but contain unique information within each sheet, all based on the same parameters. I've got cells in B14:B18 that contain label information (Earnings by Outlet) and cells in F14:18 that contain numeric...

<tbody> I wanted to use the following code to create a bubble pie chart in which the bubbles are pie charts. Dim chtMarker As Chart Dim chtMain As Chart Dim intPoint As Integer Dim rngRow As Range Dim lngPointIndex As Long Application.ScreenUpdating = False Set chtMarker =...

Hi all, Looking for some guidance. I'm wondering if anyone knows of any way to edit this VBA code so that it works with cells that are coloured via conditional formatting? If not, is it possible to bypass this issue (currently, my poor pie chart is now blank!) by using a VBA code to colour in...

I've created a pie chart with two wedges. The second wedge changes names once a certain number is met. Is there a way to format the chart to change the second wedges color when the name changes?

I’m using Excel 2007. A 2-D Pie Chart from this table, results in the 1990 No responses grouped with the Yes responses. If I reverse the table, it groups the 1990 Yes responses with the No group. Why? And how do I fix it? Did I miss a setting? Are there limits to the number of slices? Please...

Heya Everyone, The VBA code I am using for creating a pie chart works in 2007 but fails in 2003. Essentially it looks for all sheets with Test in A1 and then when located, selects G2:J2, then the last row of G:J to make the pie chart. It fails in the bolded section section. (Thanks to Mike for...

PLEASE PLEASE HELP I for the life of me cannot figure this out, I have spent the last few days trying to figure out what is wrong.... With the code below it creates a pie chart from the data in G2:J2, and then the row in G through J (Should be something like (G37:J37):biggrin...

Hello, I am trying to make a pie chart that will have a variable number of items. I am trying to make a dynamic range. ActiveChart.SetSourceData Source:=Sheets("Sheet2").Range(Sheets("sheet2").Range(Sheets("sheet2").Cells(2, 5), Sheets("sheet2").Cells(1 + eunval, 5))...

Someone please help this Excel rookie! I am trying to create a pie chart in Excel 2003 that will do the following: I want to show 2 slices of a pie chart---one 75%, the other 25%. That's easy, I know. However, in each of those slices, I want to show the other data labels and their...

Hi all- I'd like to automate transparency settings of pie charts as 100 divided by the # of categories asending over the pie slices [last value will be 0% transparent]. My reports use a single color pallete RGB (152,148,112) in case that matters, but the number of categories in each pie can...

Hi, I'm hoping for some help. I have a number of headings (Planning, Design, Build, Test, and Service Transition to Operations). Each of these headings have a duration associated with them as a figure in days. I would like to represent these Phases as segments within a Pie Chart as labels...

I am preparing an expense report and have totaled all of my expenses by category. My question now is, how do I get this report to show up in the form of a labeled pie chart? Thanks for your help!