Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I set up a pie chart to show % of same value entries
how can I show a pie chart with % of same value entries in a column eg.
values of 1,1,1,1,1,2,2,2,3,3 I want a chart to show 50% are 1's, 30% are 2's and 20% are 3's |
#2
|
|||
|
|||
Add a heading to the column of numbers, 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 number field to the row area, and another copy of the number field to the data area, as Count of number. beachlife wrote: how can I show a pie chart with % of same value entries in a column eg. values of 1,1,1,1,1,2,2,2,3,3 I want a chart to show 50% are 1's, 30% are 2's and 20% are 3's -- 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 | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel | |||
hide column but show chart | Charts and Charting in Excel |