Histogram Bin Range

[22strider]

Hello Friends

Is it possible to make Histogram chart with bin range (rather than bin points) in Excel?
I was wondering if it was possible chart with bin range like 0-15, 15-30, 30-45 rather than points 15, 30, 45.

I need to distribute chart to large number of people and was thinking range would be easier to interpret.

Thanks
Rajesh

 

[AlphaFrog]

You can bin your raw data using the FREQUENCY function or by using the Histogram add-in. Then you would graph your binned data.

 

[22strider]

But it still does not give bin range like 0-15, 15-30; I am trying to have the range (0-15,..etc.) displayed on the x-axis of the histogram chanrt rather than bin numbers (15,30,..etc.)

 

[AlphaFrog]

Put
'1-5,
'6-10,
'11-15
...etc.
in a column of cells.

Right-click on your chart and select Source Data
Select the "Series" tab on the Source Data dialog
In the "Category (x) axis labels" input box, select the range of cells with those labels.

You could use a formula to create the labels. If column C had your bins e.g. 1, 6, 11, 16 etc.
Then in say E2 put
=C2&"-"&C2+4
and copy it down column E

 

[22strider]

thanks