HOWTO: Histograms in Excel 2008 (OSX)

[andern1202]

Thank you :)

[Scroupsta]

Thank you so much, I can now finish my Maths assignment

[bonkyscrumples]

If you want to change the bins, you should just make a column with the bins in it, right click on the "select x-axis labels" option, and enter that column in!

[ZexionObsessed]

Wait a minute... This doesn't work for negative numbers, does it? HOW DO YOU DO NEGATIVE NUMBERS!!!!

[underlinedbluetext]

@ZexionObsessed hahahaha that made me giggle.

[ZexionObsessed]

@underlinedbluetext

Glad to amuse.

[ZexionObsessed]

You just saved my life.... You have no idea how long I was freaking out over this!

[OllieBrown]

Yes, but the important thing is the binning. Usually you don't already have the counts and you want to play with the bin sizes. That's the stuff I need a tutorial on. Making the bar graph is easy.

[MrTimmo3]

@OllieBrown To play with histo bin sizes, search google for "make histogram online" and choose the site with "shodor" in the name; copy & paste your data from excel; use the bin size slider to get the distribution you need; when it's right, click "show frequency table"; go back to excel with those numbers and customize color scheme & labels.

[mikeatdi]

Unfortunately, on excel 2008 this is actually the only way to create a histogram.  As far as i know anyway

[erikhensarling]

I know this is not a real histogram but it produces a similar product. If you dont like it, don't use it. Thanks.

[dankjono]

thanks so much

[lexelllll]

thanx