I was wondering if anyone else has faced this problem and has come up with a solution.
I created a XY Scatter chart in Excel 97 and the X axis is the date, and the Y is the temperature. The min/max for the X axis is set to auto select but the Y min is 1/1/1979 and the max is 1/1/2003. The major unit is 730.5 and the minor unit is 365.25. This should display everyother year on the X axis, but instead it shows 79,80,83,84, and so on. Is there away around this problem but by still us the same date values?
Thanks,
dan...
I created a XY Scatter chart in Excel 97 and the X axis is the date, and the Y is the temperature. The min/max for the X axis is set to auto select but the Y min is 1/1/1979 and the max is 1/1/2003. The major unit is 730.5 and the minor unit is 365.25. This should display everyother year on the X axis, but instead it shows 79,80,83,84, and so on. Is there away around this problem but by still us the same date values?
Thanks,
dan...