Pie Chart
I have a column titled "On time" the entries underneath this title are
either"Yes", "NO", or "NOT COMPLETED". I want to create a pie chart with the percentages of Yes and NO. Please help. Thanks in advance. |
In one cell, use the formula =COUNTIF(A1:A100,"=YES"). In another,
=COUNTIF(A1:A100,"=NO"). Build your graph from the results of those two cells. Hope this helps. Jane "Dahlman" wrote: I have a column titled "On time" the entries underneath this title are either"Yes", "NO", or "NOT COMPLETED". I want to create a pie chart with the percentages of Yes and NO. Please help. Thanks in advance. |
I don't understand. this is what my sheet looks like:
Project Name Sheduled Date Completed Date On time blah blah 2/28/05 2/28/05 Yes bling blah 3/5/05 3/6/05 No and so on... My on time column is a formula. I need to create the chart based on what I'm getting in that column. |
You could create a pivot table to summarize the data, and create a chart
from the pivot table results. There are instructions for pivot tables in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Dahlman wrote: I have a column titled "On time" the entries underneath this title are either"Yes", "NO", or "NOT COMPLETED". I want to create a pie chart with the percentages of Yes and NO. Please help. Thanks in advance. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
You'll need to create total rows somewhere -- at the bottom or top of your
current spreadsheet or on a new sheet. The pie can't count yeses and nos. It can only graph based on an inputted number. So, at the bottom of the rows of data, you should have a total row for yeses and one for nos, using the formulas I listed earlier. "Dahlman" wrote: I don't understand. this is what my sheet looks like: Project Name Sheduled Date Completed Date On time blah blah 2/28/05 2/28/05 Yes bling blah 3/5/05 3/6/05 No and so on... My on time column is a formula. I need to create the chart based on what I'm getting in that column. |
Thanks again Jane. You've helped me twice tonight. I appreciate it.
"Dahlman" wrote: I have a column titled "On time" the entries underneath this title are either"Yes", "NO", or "NOT COMPLETED". I want to create a pie chart with the percentages of Yes and NO. Please help. Thanks in advance. |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com