Excel chart using time data

**jopat** · 07-25-2017, 01:07 AM

Hi All,

I'm trying to plot a bar graph on the below columns

Column A is text
Column B is entered as hh:mm

When I try to plot the graph I get this Graph - A and B Column.JPG

How can I get it so that Column A is on the X Axis and then Column B is on the Y Axis?

Any help is appreciated. Thanks Mal

Column A B
0900-1000 2:43
1000-1100 2:59
1100-1200 2:53
1200-1300 2:41
1300-1400 2:51
1400-1500 2:45
1500-1600 2:46

**sandy666** · 07-25-2017, 01:43 AM

something like this?

If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.