ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   histogram setup in excel (https://www.excelbanter.com/charts-charting-excel/77-histogram-setup-excel.html)

pfcaines

histogram setup in excel
 
How do you display an age range (Ex: 4-9) as the bin data in a histogram?


Barb Reinhardt

http://office.microsoft.com/en-us/as...109481033.aspx should get
you started.

"pfcaines" wrote in message
...
How do you display an age range (Ex: 4-9) as the bin data in a histogram?




Michael R Middleton

pfcaines -

How do you display an age range (Ex: 4-9) as the bin data in a histogram?
<


Use the Histogram tool with your raw data and a bin range containing the
upper limit of each age range. Then change x-axis data of the Column chart
to use the text labels you want.

For more info, read the first few pages of "Better Histograms Using Excel,"
available at www.treeplan.com.

- Mike

www.mikemiddleton.com




All times are GMT +1. The time now is 06:47 PM.

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