Forum Discussion
Using Data Analysis tool pak to create histograms
Hello I am trying to create a histogram for the data on acorn size in mm for two collection sites. Site 1 is titled Creek, and site 2 is titled River. RIVER Site data is: 5.8 5.2 5.7 4.2 4...
Here is a screenshot with the Histogram tool from the Data Analysis :
I already did the "River" data as shown in the histogram in F2:G8 and the chart next to it and the current Histogram input window is set to repeat for the Creek data. The key is that you need to create the list of Bin values (see D2:D6) before launching that tool so you can point to that range.