Better Histograms Using Excel

www.TreePlan.com

Add-Ins for Microsoft® Excel® 2000-2010 (Windows®) and Excel® 2004 & 2011 (Macintosh®)

Better Histograms Using Excel
For Microsoft® Windows® Excel® 2000-2010 and Macintosh® Excel® 2004

A histogram is usually shown in Excel as a Column chart type (vertical bars). The labels of a Column chart are aligned under each bar, and there is no Excel feature for changing the alignment. A better histogram has a horizontal axis with numerical labels aligned under the tick marks between the bars as shown below.

Download a free add-in for automatically creating a better histogram from data on a worksheet.

Right-click and choose Save Target or Save Link to download a pdf file with step-by-step instructions for using Excel 97-2004 commands to create a better histogram. For Macintosh, instead of right-click, hold down the ctrl key, click the link, and choose "Download Link to Disk."

Click to open the same pdf file with Excel 97-2004 instructions in your browser.

Open an html file in a separate window with the same Excel 97-2004 step-by-step instructions.

Version History of the Better Histogram Add-In (new at top, old at bottom)

2007 May
BetterHistogram_20070222_2050.xla
Added support for Excel 2007.

2005 October
BetterHistogram_20050809_2120.xla
Added support for having negative values in the data set, which had caused an error.

2004 December
BetterHistogram_20041212_1815.xla
Removed Control+Shift+h shortcut key, which had caused an error when installing by Excel's Add-In Manager.

2004 November
BetterHistogram_20041116_1820.xla
Original version.

Microsoft, Windows, Excel, and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Apple, Macintosh, and Mac are trademarks or registered trademarks of Apple Inc. in the United States and/or other countries.
Copyright © 2011 TreePlan Software. All Rights Reserved.