Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pie Chart Help
Can anyone help? I have a spreadsheet to which I have one column that has
different letters in, I need to create a pie chart that shows the amount of the same letter (i.e. 'P's in blue, 'F's in red etc) just so I can show how many of one letter there is? Any ideas and please explain fully as I am quite a new user |
#2
|
|||
|
|||
Add a heading to the column of letters then you could create a pivot
table to summarize the data, and create a pie 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 In the pivot table, add the letter field to the row area, and another copy of the letter field to the data area, as Count of Letter hclements wrote: Can anyone help? I have a spreadsheet to which I have one column that has different letters in, I need to create a pie chart that shows the amount of the same letter (i.e. 'P's in blue, 'F's in red etc) just so I can show how many of one letter there is? Any ideas and please explain fully as I am quite a new user -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel |