Format A Chart Axis?

[charllie]

Hi Folks,

I have format my axix for chart 1 which is in time format, so it looks like this:

• Minimum = 0.5 (12:00 midday)
  
  Maximum = 1.0 (00:00 Midnight)

So the graph starts at 12:00 midday and finishes at 00:00 Midnight.

I am now trying to format my axis for chart 2 like this so it will start at 00:00 Midnight and finish at 12:00 midday.

• Minimum = 1.0 (00:00 Midnight)
  
  Maximum = 0.5 (12:00 midday)

However it won't allow me to do it saying that the maximum needs to be a higher value than the minimum.

Does anyon know a differnet way that i could change chart 2 so it starts at 00:00 Midnight and finishes at 12:00 midday?

Thanks

 

[Jon Peltier]

1) Midnight also equals zero, so go from 0 to 0.5.

2) Use a fully qualified date-time. Today is 38672; noon was 38672.5, dinnertime was around 38672.75, etc.

 

[charllie]

Hi Jon,

Thanks for your reply. That seemed to work perfectly.

Thanks