If I understand you correctly:
Enter =RANDBETWEEN(1,6) into cell A1 and copy down to
A100, for example.
Type 1,2,3,4,5,6 into cells B1,B2, ...,B6.
Enter =COUNTIF(A:A,B1) into cell C1 and copy down to cell
C6.
Select cells B1:C6, goto menu Insert/Chart and try some
charts you like.
HTH,
Bernd
|