ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I get a histogram using EXCEL (https://www.excelbanter.com/charts-charting-excel/155880-how-do-i-get-histogram-using-excel.html)

ngwenya

How do I get a histogram using EXCEL
 
Using Office 2007 how to you draw a histogram, given grouped data and
frequency?
I know you could do this with 2003 using the tools option.
Thanks


Mike Middleton

How do I get a histogram using EXCEL
 
ngwenya -

If the data are already grouped, create a Column chart type.

The Histogram tool is used when you have ungrouped, raw data. It prepares a
frequency distribution, i.e., it groups the data, and then it creates a
Column chart.

If you have the original, ungrouped, raw data, you can use the Histogram
tool, or you could use my free Better Histogram add-in, available at
www.treeplan.com.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"ngwenya" wrote in message
...
Using Office 2007 how to you draw a histogram, given grouped data and
frequency?
I know you could do this with 2003 using the tools option.
Thanks





All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com