Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Greetings from the UK...
I have a list of around 1000 numbers, all integers whose values can range from 1 through to 4000. Most of these numbers repeat themselves in the list . What I want to do is produce a chart showing the number of times each descrete number appears , its value and the percentage of times it appears in the list . I think ( dangerous for me !) I should be looking at a histogram or a even a pie chart but so far my attempts (using the data analysis and chart wizards) are not what I want. As an example a list of 12 numbers could be 2, 3, 2, 4, 2, 4, 2, 2, 4, 2, 4,3 and what I want to get to is a chart showing that: "2" appeared 6 times in the list equating to 50% of the 12 entries, "4" appeared 4 times in the list equating to 33.3% of the12 entries, "3 " appeared 2 times in the list equating to 16.6% of the 12 entries value anyones help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Editing a Chart Directly?? | Charts and Charting in Excel | |||
Editing a Chart Directly?? | Charts and Charting in Excel | |||
Chart formatting | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |