Histogram Help
Posted by Duncan on December 03, 2001 1:36 AM
I am attempting to create a histogram within excel and having some difficulties.
Suppose we have data between 0 and 10 and bins of 0 to 1, 1 to 3, 3 to 6, 6 to 7 and 7 to 10.
Ideally I would like to see bars whose width represents the width of the bin and the x-axis labels being such that 0 appears at the origin, 1 appears at the right hand corner of the first bar, 3 at the right hand ciorner of the 2nd bar and so on.
However, the x-axis labels are placed in the centre of the bar rather than at the sides and the bins are given equal width.
Does anyone know how to sort this out?
Thanks
Duncan
Posted by S. Patel on December 03, 2001 9:16 AM
There is no easy way...
What you can do however is create a set of data which you will then plot onto an x-y scatter.
The data must be constucted as follows and will literally allow you to join the dots....
assume my data looks like this
x y
0-1 10
1-3 5
3-6 7
etc..
I would then plot the follwing...
x y
0 0
0 10
1 10
1 0
1 5
3 5
3 0
3 7
6 7
6 0
etc...
Plot this and then add a line and it will
join the dots accordingly...
Crude method but works...
Shoaib
Posted by Duncan on December 05, 2001 3:05 AM
Excellent. Thanks for that.
Is there any way to colour underneath the lines?
D.
