Hi,

I like to create a chart showing "time" on y axis start from 17:00 and end 16:00, on x axis the "date". The idea is i like to plot what time a specific job is finish after 17:00 every day. Some day the job is finish before midnight other days after midnight.

Hi Jehra,

When the job finishes after midnight its on next day right not on the same day.

This is the only way you can represent the data accurately.

y axis start from 17:00 and end 16:00 doesn't make sense it should be for full 24hrs. Excel will not consider 16 greater than 17 unless the date changes. But if you put the dates with time, you can no longer compare different dates on X axis.

I did this:

1. Create a line with markers chart with only time range selected

2. Then on the Chart select the x-axis rightclick select data

3. Click Edit on the horizantal axis labels. Select the Actual Date range this time.

4. Right Click the y-axis format ->axis options->bounds->min 0 ,max 1.0

5. Select the Line and right click add data labels.

You can combine the Job Date too on the step 3 to get a different