I’m confused by your nomenclature here… Are you just “rolling” some number of dice and looking for a histogram of the results? If so, it’s probably easiest to write a program to tally up the results appropriately and then just plot it in Excel. The brute-force way to do it would be the following: If you ran your program and got the results
then you’d just run a loop that cycled you through the entire list, incrementing the elements of another array appropriately. In pseudo-code,
For x = 1 to length(results);
histogram(results(x)) = histogram(results(x)) + 1;
This would result in the list “histogram” containing the values
which are, respectively, the number of 1’s in “results”, the number of 2’s in “results”, etc.
For the record, Excel does have some histogram-generating abilities of its own, but they’re kludgy and not all that straightforward. If you’re already using a programming language, better to generate the histogram data directly.