| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to create a pie chart with 793 numbers? Possible?
Hi, I've been trying to create a pie chart with 793 numbers on one single
colum, the column consists of various numbers and i would like to take a percentage of numbers on the column, for example there are 100 tens ranging from cell A1 to A99 and 500 1's ranging from cell A100 to A699 and other numbers, is it possilbe to create a pie chart with that many numbers? -- Every time i tried to create the pie chart using the chart wizard, the finished chart will always shown with so many different slices, any tips on how to create the pie chart would be greatly appreciated thanks in advance. Mike |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to create a pie chart with 793 numbers? Possible?
Do you want to group the numbers or what do you want to do?
If you want to group the numbers then it would be handy to use a pivot table, in the layout put the header first in the row and then in the data fields, then doubler click the header in the data field and select count. then makem a chart out of that -- -- Regards, Peo Sjoblom "excelnovice123" wrote in message ... Hi, I've been trying to create a pie chart with 793 numbers on one single colum, the column consists of various numbers and i would like to take a percentage of numbers on the column, for example there are 100 tens ranging from cell A1 to A99 and 500 1's ranging from cell A100 to A699 and other numbers, is it possilbe to create a pie chart with that many numbers? -- Every time i tried to create the pie chart using the chart wizard, the finished chart will always shown with so many different slices, any tips on how to create the pie chart would be greatly appreciated thanks in advance. Mike |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to create a pie chart with 793 numbers? Possible?
Thank you very much for your help, greatly appreciated.
Mike D "Peo Sjoblom" wrote: Do you want to group the numbers or what do you want to do? If you want to group the numbers then it would be handy to use a pivot table, in the layout put the header first in the row and then in the data fields, then doubler click the header in the data field and select count. then makem a chart out of that -- -- Regards, Peo Sjoblom "excelnovice123" wrote in message ... Hi, I've been trying to create a pie chart with 793 numbers on one single colum, the column consists of various numbers and i would like to take a percentage of numbers on the column, for example there are 100 tens ranging from cell A1 to A99 and 500 1's ranging from cell A100 to A699 and other numbers, is it possilbe to create a pie chart with that many numbers? -- Every time i tried to create the pie chart using the chart wizard, the finished chart will always shown with so many different slices, any tips on how to create the pie chart would be greatly appreciated thanks in advance. Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Chart How do I create Y axis to represent numbers I am using | Charts and Charting in Excel | |||
| create line chart with two axises in Pivot Chart | Charts and Charting in Excel | |||
| how to create a chart from the source which does not have explicit numbers | Charts and Charting in Excel | |||
| Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
| create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
