Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a pie chart in Excel
Hi,
I have an excel sheet with 1 column. Fields in this column can have either a "Yes" value or a "No" value. I would like to make a pie chart where all the "Yes" would be in 1 color and the "No" in another color. Is this possible with Excel? Thanks, Jeremy Pullicino |
#2
|
|||
|
|||
Kelly
If your column is A, then in B2 enter =COUNTIF(A:A,"Yes") and in B3 enter =COUNTIF(A:A,"No") and chart that HTH Nick Hodge "Kelly Wagner" wrote: Hi, I have an excel sheet with 1 column. Fields in this column can have either a "Yes" value or a "No" value. I would like to make a pie chart where all the "Yes" would be in 1 color and the "No" in another color. Is this possible with Excel? Thanks, Jeremy Pullicino |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
Ignoring characters in excel sheets when creating a chart | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |