Intervals of time

[endri81]

I have a table looking like

05:00-06:00 25
06:00-07:00 12
...
Wanna build a histogram showing frequencies during intervals of time.
Any help?
Regards

 

[Robert Mika]

like this?

 

[endri81]

yes thx

 

[Robert Mika]

In Exel 2007 or 10:


Select your data-->Insert--Charts-Column-->2-D column

Then Click right On the chart-->Format Data series-<Gap Width "0%"


Example

http://www.filesonic.com/file/1691562394/Chart.xlsx