Using two variations, without a secondary X axis and with a secondary X
axis, I was able to change the maximum by selecting Fixed and entering
1/5/1900. Entering just 5 does not work in 2007, because they forgot
that even in axis scale input boxes, numbers can have different formats.

Make sure you have SP2 installed. The original release of 2007 had lots
of chart glitches, SP1 solved many, SP2 solved many, and many remain.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/7/2010 10:43 PM, David wrote:
Date Series 1 Series 2
1 43 10
2 45 11
3 45 14
4 67 16
5 89 13
6 90 #N/A
7 89 #N/A
8 88 #N/A