There is probably a built-in way to do that, but it's also easy to do manually. Bring up the worksheet containing the bin counts and enter the following commands in the script window. (If the column with the bin counts is not named B, then substitute its correct name in the col() expressions first.)...wo -c Percents; // add a column called Percents
sum(col(B)); total=sum.total; // get the total count
col(Percents)=100*col(B)/total;
The percentages are now in the Percents column and you can plot them any way you like.
Mike Buess
Origin WebRing Member
Histogram with percentages
Posted - 10/09/2001 : 09:48:43 AM
