Missing Axis Category Labels

[CruisJR]

Excel 2003 worksheet opened in Exceel 2007. Data is 15 (0, 15,30, 45) minute
readings by hr. by date. When making chart from pivot table, area chart
shows date, hour, and minute labels for day 1 only, day 2 - end of chart only
show munute labels. Missing are Category labels for date and hour.

 

[CruisJR]

Thought an example might help.
Chart data is from Pivot Table

Day Hour Min Total
2/1/2007 0 0 12.6
15 12.9
30 12.9
45 12.9
1 0 12.9
15 13.1
30 12.2
45 12.8
2 0 13.5
...continues
23 0 13.1
15 12.9
30 12.7
45 12.1
2/2/2007 0 0 12.1
15 12.9
30 13.0
....repeats like this to end of month.


Excel 2003 chart labels look something like this; (|=tick mark grid lines)
----------------- ---------------------------------
------------------------------
|0134|0134|01 34|0134|0134|0134|0134|0 0134|0134|0134|0134|01
|0 |1 |23 |0 |1 |2 |3 23 |0 |1
|2 |3
| 2/1/2007 | 2/2/2007 |
2/28/2007

Excel 2007 chart labels look something like this; (only displays day 1 labels)
----------------- ---------------------------------