I agree that you probably want a histogram. I have a page that explains
a few ways to make a histogram:

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Kev wrote:

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.