building a chart to display time periods

**Don Juan** · 11-21-2009, 05:10 AM

Hello all,

I need help making a chart to display a time period. I already have it mostly done but I seem to have to sticking points. One is I can't seem to adjust my time on the axis to be 6:00am to 12:00am. Two, my bar graph is not displaying right. To better illustrate I included the program with better instructions next to the problem area. Thank you for taking the time to look at it.

**teylyn** · 11-21-2009, 05:29 AM

One is I can't seem to adjust my time on the axis to be 6:00am to 12:00am

Format the X axis scale with

minimum = 0.25
maximum = 0.583333333

To find out what a time value is in decimals, put the time into a cell, e.g. 6:00 am, and then format as General and it will display as 0.25. That's the value you need to enter in the axis scale tab.

Two, my bar graph is not displaying right.

Would you care to elaborate? There's so much going on in the spreadsheet that I would have to spend a whole hour to figure it all out. I'm sure it'll take you less time to point me to it.

cheers

**Andy Pope** · 11-21-2009, 07:31 AM

The value for the time bar is too large. You need to calculate the time between start and finish.

M21: =TIME(MID(B7,6,2),MID(B7,8,2),0)-TIME(LEFT(B7,2), MID(B7,3,2),0)