#### Help with pie chart

```I want to see if there is a way to create a pie or other chart that shows the
percentage of total yes that come from each individual with the below data
table...

# of Yes	# of Calls	% Yes	% of Total Yes
Frank	  - 	  - 	-	0%
Leo	 3 	 3 	100%	60%
Shammy	  - 	  - 	-	0%
Rosalia	  - 	  - 	-	0%
Katie	  - 	  - 	-	0%
Hector	 2 	 2 	100%	40%
Arash	  - 	  - 	-	0%
Abdool	  - 	  - 	-	0%
Alvaro	  - 	  - 	-	0%
Totals	 5 	 5 	100%

```
 0
Leonard (22)
1/12/2007 5:53:05 AM
excel.charting 18370 articles. 0 followers.

2 Replies
367 Views

Similar Articles

[PageSpeed] 12

```You can either plot the percentages, or plot the #Yes column and select the
data labels option to show percentages.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"Leonard" <Leonard@discussions.microsoft.com> wrote in message
news:1105D5FE-D800-4D6F-8BDB-7D899B7E8FF5@microsoft.com...
>I want to see if there is a way to create a pie or other chart that shows
>the
> percentage of total yes that come from each individual with the below data
> table...
>
>
> # of Yes # of Calls % Yes % of Total Yes
> Frank   -   - - 0%
> Leo 3 3 100% 60%
> Shammy   -   - - 0%
> Rosalia   -   - - 0%
> Katie   -   - - 0%
> Hector 2 2 100% 40%
> Arash   -   - - 0%
> Abdool   -   - - 0%
> Alvaro   -   - - 0%
> Totals 5 5 100%
>

```
 0
jonxlmvpNO (4558)
1/12/2007 1:16:24 PM
```Worked... Thanks for your help.

"Jon Peltier" wrote:

> You can either plot the percentages, or plot the #Yes column and select the
> data labels option to show percentages.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Leonard" <Leonard@discussions.microsoft.com> wrote in message
> news:1105D5FE-D800-4D6F-8BDB-7D899B7E8FF5@microsoft.com...
> >I want to see if there is a way to create a pie or other chart that shows
> >the
> > percentage of total yes that come from each individual with the below data
> > table...
> >
> >
> > # of Yes # of Calls % Yes % of Total Yes
> > Frank   -   - - 0%
> > Leo 3 3 100% 60%
> > Shammy   -   - - 0%
> > Rosalia   -   - - 0%
> > Katie   -   - - 0%
> > Hector 2 2 100% 40%
> > Arash   -   - - 0%
> > Abdool   -   - - 0%
> > Alvaro   -   - - 0%
> > Totals 5 5 100%
> >
>
>
>
```
 0
Leonard (22)
1/16/2007 7:27:00 AM

Similar Artilces:

Chart wizard funcitonality in Excel 2007?
I hope I'm missing something in Excel 2007. In Excel 2003, the chart wizard gives you access to lots of options when you create a graph--graph type, data range, the various series (including the X axis labels), the chart title and axis titles, gridlines, legends, and others. It doesn't take long to create the graph with most of the options you want and then tweak it pretty quickly. In Excel 2007, it seems that every option is a separate button/menu/choice. Setting the chart title, the x-axis title, and the y-axis title are three different operations. Ditto for pretty much everyt...

Creating a Combination Bar Chart with 2 Lines
I am trying to create a bar chart with 2 line series. The Y-axis for the vertical bars would be on the left and the Y-axis for the 2 line series would be on the right (3 series were defined). The horizontal axis for all series are calendar months (Jan, Feb, etc.) Every time I setup the chart my chart only displays a single line, ignoring the other line series. The vertical bars come out fine. Any thoughts on what I am doing wrong? Thanks Bill Falzone Don't use the built in types. Make the chart using all columns. Select a series that you want to change (click on it right in th...

Help with DLookup
I have a DLookup function on my form and it works by finding the information once I exit and then re-enter the form, it does not bring in the information as soon as I enter the information in the lookup field. =DLookUp("[Employee Name]","[Employee Information]","[Employee ID]=forms![Timesheet Entry]![Employee ID]") Does anybody know why it is not updating immediately? All help is greatly appreciated Where are you using this expression -- as the control source of a textbox? More details about the form's design and how you're using the form, please....

Conditional Formating Help
Hi I wonder if anyone could help me, I am after code for the following. cell e6 = Keys Sent Column f6 = Keys due Column g6 = Keys received What I want the script to do is if there is no value in g6 and todays date is greater then the date stated in F6, then the cell turns red (prompt to inform me that keys are late). Many thanks Dan Use a CF formula of =AND(G6="",TODAY()>F6) HTH Bob "housinglad" <housinglad@discussions.microsoft.com> wrote in message news:A5887369-33DA-489A-BEC9-8173707313C6@microsoft.com... > Hi > ...

I have created a time roster.. easy in each day I have start,end and break deduction.. still no probs I need to create an output formula for hours worked after a 16:00 from the start and end range on a day. So in the roster it will still display normal hours, however I will create a field for hours after 16:00. this is for calculating a different wage rate. Thanks Aaron See response in .programming -- HTH RP (remove nothere from the email address if mailing direct) "Aaron H" <aaron@istarnetworks.com.au> wrote in message news:uU96kXI\$EHA.2076@TK2MSFTNGP15.phx.gbl... ...

HELP- error Outlook
What's this mean and how to fix? in error dialogue box: "c:\program~1\micro~2 \office\outlook.exe" Abnormal program termination .. ...

help diagnosing what's going on in ExchangeServer2000
I'm fairly ignorant of exactly how ES2000 works and would like some general information to help in my diagnosing why some emails are not being delivered to certain email domains (more correctly, why some emails are not being forwarded actually...ES2K is part of a voicemail system where some users have ..wav copies of the voicemails forwarded to their various off-site email accounts) . Here are my questions: 1. How can I see what emails are being forward? Is there a file/folder akin to the SentItems folder in Outook? 2. If there are send failures, where can I find them and how can ...

We have an urgent question regarding credit card setup/cash receipts/bank rec We understand that in Great Plains when setting up a Credit Card to be used by a Customer, it must be setup as a "Bank Card", not a "Charge Card", in order for the transaction to hit Bank Rec. However, we mistakenly setup all the Credit Cards as "Charge Cards", therefore after posting Credit Card Cash Receipt transactions in Receivables, the transaction does not appear in Bank Rec for us to perform Bank Deposits. Please Please Help!!! Is there any way to "fix" those pos...

How do I turn the pivot chart into a list with all cells filled?
I have the pivot chart and would like to copy and paste it so that all fields are filled Select the pivot table. Choose Edit>Copy Select the cell where you'd like to paste the copy Choose Edit>Paste Special Select Values, click OK There are instructions here for filling the blanks: http://www.contextures.com/xlDataEntry02.html gianna wrote: > I have the pivot chart and would like to copy and paste it so that all fields > are filled -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html ...

Best tool for adding a pivot chart like chart to a report?
Is it the PivotChart form or should I used the MSChart OCX? Which is easier to set up/configure to display the data properly? (A multi-column, multi-entity bar chart) Which is the most flexible? And where can I find tutorials on using both? Thanks Kyle Jedrusiak ...

Creating a time chart
Can someone tell me if this is possible. I want to be able to create a chart that represents a week. There will be seven bars and each bar will represent the day my business is open. I want to be able to enter starting times in one column, let's say column B and a quitting times in column C. These two columns represent Sunday. I want D and E to represent Monday. I'll do this for all seven days. Is there a way I can create a stacking bar chart (or any chart) that will place a bar representing that employee's shift in the chart. All bars will not start on the horizontal axis, b...

paired bar chart
Is it possible to create a paired bar chart in Excel? please define paired bar chart? "abj2" wrote: > Is it possible to create a paired bar chart in Excel? See Jon Peltier's site on Tornado Charts http://www.peltiertech.com/Excel/Charts/tornadochart.html "abj2" wrote: > Is it possible to create a paired bar chart in Excel? ...

help with unusual request
Hello everyone, My boss has hit me with an odd request and I would like to ask for someone to point me in the right direction. What he wants is everytime anyone sends or recieves an email that a copy is made that he can get to anytime he wants. I talked to him about our daily backups, but he wants something that's realtime and that he can get to whenever he wants. I'm stuck and looking for ideas. We're currently on Exchange 5.5 with all of the latest service packs and patches. Any and all help is very much appreciated. You can enable "message journaling" fea...

Help designing a checklist in access
Hello All My company currently uses excel checklists to ensure that projects are completed fully. we have around 10 different checklists. each checklist (excel file) has 6 sheets, each sheet 15 questions or steps. most answers are Y,N,NA and the employees put their initials in the correct answer column. Many questions are redundant throughout the 10 checklists. I would like to create the checklists in access because their are too many excel files getting lost and if we change question/ step. we have to change it multiple times. the employees need to enter a clients name and then choose the c...

Timesheet Pseudo Tied Mode
I'm hoping that I might have a colleague out there who could help me offline figure out how to install this open source utility (unsupported by Microsoft but apparently works OK for some of their clients) that streamlines the Timesheet process (automatically synchronizes the data into My Tasks whenever a timesheet is saved). I'm not sure where to start and may need someone to bounce questions off of - especially if you've been successful with it. Thanks, Andy Novak UNT Hi Anovak, We installed it (still using the version 1.3 based on event handler) and we're usi...

I'm trying to create an SMTP Connector in Exchange Server 2003, to have our company's email sent out (Internet/External emails) to a specific mail forwarder server (the "specific" server is our ISP/Firewall provider server). But I'm having problems understanding how to set this up properly with our Exchange 2003 Server, I know I have to create a new SMTP Connector but not sure what settings to make. Could someone please help me with this. Thanks William On Thu, 25 Feb 2010 22:41:39 -0500, "Bill" <wstyler@verizon.net> wrote: >I&...

When I print a Payables check batch, several invoices within the batch are printing incorrectly as \$0.00 amount, even though it should be paying off a certain amount. The problem seems to be with invoices that are applied to credit memos. Say I have an invoice for \$500 and I apply a credit memo of \$80 to the invoice, when I go back to pay the invoice, it should pay \$420, but instead it shows \$0.00 under amount paid column of check stub. Does anyone know why this is occuring? By the way, I am using MICR check printing. ...

Help in turning off underlining and blue font
Hello, Does anyone know if there is a way to turn off the automatic underlining and blue font of the text when entering a email address in a cell? Thanks, Bob Tools / Autocorrect options / Autoformat Tab / Replace Network paths with hyperlinks - Deselect it -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ----------------------------------------------------------------------...

Help!!Getting audio files to play continuously during slide show?!
I have Powerpoint 2002, and i am having a hard time getting the music file to play continuously during the slide show. it plays on the first slide (which is the only slide that has the little speaker picture on it), but then it doesn't transition to the next slide until after the song is done, when i want the song to play while the slides are transitioning. HELP please! Mega, Have a look here and see if it helps, there are tuturials in video demonstrating the process. http://www.pptfaq.com/FAQ00047.htm -- Luc Sanders MVP - PowerPoint "MegaB86" <MegaB86...

Help with counting formula
Sheet 1, Row 1, Column 2 - opening hours divide into 15min segments. B1 - 08:00, C2 - 08:15, D2 - 08:30, and so on. Sheet 2 , Columns 1 and 2 - a list of each agents break times. Column A - Start time (eg 10:00) and Column B - End time (eg 10:30). Sheet 1, Row 2, Column 1 - summary titles. (eg Cell A2 - "Morning Break"). Problem: I need to summarise the number of agents away on, say, "Morning Break" per 15 min segment. So, B2 must count the number of people on "Morning Break" at 08:00, B3..the number of people of people on morning break at 08:15, a...