HOWTO: Histograms in Excel 2008 (OSX)
Loading...
Uploader Comments (erikhensarling)
All Comments (12)
-
Thank you :)
-
Thank you so much, I can now finish my Maths assignment
-
@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.
-
Glad to amuse.
-
@ZexionObsessed hahahaha that made me giggle.
-
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!
-
Wait a minute... This doesn't work for negative numbers, does it? HOW DO YOU DO NEGATIVE NUMBERS!!!!
2 years ago 2
-
You just saved my life.... You have no idea how long I was freaking out over this!
-
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.
-
Unfortunately, on excel 2008 this is actually the only way to create a histogram. As far as i know anyway
- 3:27
histogram_excel2007.mp4by mathclips10,716 views
- 1:18
Histogramasby luwala200726,837 views
- 5:45
Two Ways to Create a Frequency Distribution Report in Excelby DannyRocksExcels15,305 views
- 2:55
Histogramasby joseluishg6871,414 views
- 5:33
How to Create a Frequency Distribution Chart in Excelby crboswe55,372 views
- 1:33
Pareto Excel 07by SochiTag58,007 views
- 4:16
Creating a Histogram In Excel 2010by waxwing11186,666 views
- 2:45
Creating a Histogram using Excelby TheMathClips12,655 views
- 6:41
How To...Plot a Normal Frequency Distribution Histogram in Excel 2010by eoloughlin24,492 views
- 2:39
Excel 2008 for Mac Charts Step 1by HampshireCollegeIT1,936 views
- 4:20
Histogram and Frequency Distribution in Excelby meaniefiene128,920 views
- 0:35
how to change the x axis on a graph in excel 2007by ozzywilder19,637 views
- 9:39
Introduction to Excel for Mac - 1by gauravnjoshi29,963 views
- 7:38
Graphing with Excelby gr57595,782 views
- 9:35
Format the Area and Legend of a Chart in Excel - Walkthroughby excelteacher2,198 views
- 4:56
Excel 2008 for Mac Charts Step 2by HampshireCollegeIT1,145 views
- 7:08
Histogramsby richardribaudo28,173 views
- 5:46
Creating a Frequency Polygon in Excelby aeronives15,250 views
- 3:17
X-Value Data & Labels in Excel 2008 (OSX)by erikhensarling32,676 views
- 6:10
How To Create a Line-Graph in Excelby graphmaster31399,300 views
I know this is not a real histogram but it produces a similar product. If you dont like it, don't use it. Thanks.
erikhensarling 3 years ago