Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
pfcaines
 
Posts: n/a
Default histogram setup in excel

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

  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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?



  #3   Report Post  
Michael R Middleton
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 4 April 25th 23 11:47 AM
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM
Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! Marie J-son Charts and Charting in Excel 2 December 6th 04 04:11 AM
Excel 2003 BLG Charts and Charting in Excel 1 December 3rd 04 02:15 PM
Is there a way to create a standard OHLC bar chart in Excel? [email protected] Charts and Charting in Excel 3 December 2nd 04 09:49 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"