View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default X Y (Scatter) Chart EXCEL 2007

I am plotting times on both X and Y axis.

Y axis is fine.

Underlying data fills A 1 to C 7 only.

Data in column B and C is formatted as Time 13:30:55.

Y axis formats correctly as (from top to bottom):-

14:00:00
13:00:00
12:00:00

- and so on down to and including:-

06:00:00

I want exactly the same format on the X axis.

To format X axis I take following actions:-

- go to Format Axis pop up window

- Number tab change this to Time 13:30:55

- Axis Options tab Minimum: Fixed 0.25
- Axis Options tab Maximum: Fixed 0.58333 (As soon as I do this all the
points disappear from chart)
- Axis Options tab Major unit: Fixed 0.041666

Close.

Why have all the points disappeared from the chart?

Times now read corrrectly (from 06:00:00 to and including 14:00:00 along
the X axis).

TIA for any replies.