Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have the following data that I want to chart in a pie chart. The following
are mutiple choice answers to questions on a survey. The left column are dollar amounts and the cells are formatted (currency) The right column are the number of people who chose that answer. $125 6 $150 3 $250 49 $275 5 $300 2 $500 59 When I chart these in a pie chart, I get the following pieces to the pie. 1 8% 2 9% 3 16% 4 17% 5 19% 6 31% It just numbers the pieces and gives me the wrong percentages. Does anyone know what could be happening? Can I use a pie chart for currency or should I use a bar chart? Any help would be greatly appreciated, Karen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Area Chart not refreshing/updating properly | Charts and Charting in Excel | |||
Chart Won't Display Properly | Charts and Charting in Excel | |||
Pivot Chart not filtering properly | Excel Discussion (Misc queries) | |||
ploting properly spaced "day" chart | Charts and Charting in Excel | |||
Symbols not displayed properly in Excel chart | Excel Discussion (Misc queries) |