Date Range Malfunction Johnnie 12/23/2008 3:08:16 PM I have created a chart starting from scratch and using the wizard and I still can not get to work right. This is what I have entered Data Range: ='Dollar Forecast'!$A$3,'Dollar Forecast'!$C$3:$AX$3,'Dollar Forecast'!$A$31,'Dollar Forecast'!$C$31:$AX$31,'Dollar Forecast'!$A$33,'Dollar Forecast'!$C$33:$AX$33 Series 1 Values: ='Dollar Forecast'!$C$31:$AX$31 Category (X) axis labels: ='Dollar Forecast'!$C$3:$AX$3 Series 2 Values: ='Dollar Forecast'!$C$33:$AX$33 Category (X) asix labels: ='Dollar Forecast'!$C$3:$AX$3 Based on the above information, my chart should start on October 5. However, it insists on starting on August 2 although my data does not go back that far. I have change the scale information to start on 10/5, but it keep reverting to 08/02. Any ideas what may be causing this? I use Excel 2003. Thanks in advance for your help. Happy Holidays! Johnnie

Re: Date Range Malfunction "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/23/2008 3:54:24 PM "Johnnie" <jdelariva[ at ]rbccorp.com> wrote in message news:49BCD8F9-A3FA-4325-ADB8-ED82EE4CF4A4[ at ]microsoft.com... [Quoted Text] >I have created a chart starting from scratch and using the wizard and I >still > can not get to work right. This is what I have entered > > Data Range: > ='Dollar Forecast'!$A$3,'Dollar Forecast'!$C$3:$AX$3,'Dollar > Forecast'!$A$31,'Dollar Forecast'!$C$31:$AX$31,'Dollar > Forecast'!$A$33,'Dollar Forecast'!$C$33:$AX$33 > > Series 1 > Values: ='Dollar Forecast'!$C$31:$AX$31 > Category (X) axis labels: ='Dollar Forecast'!$C$3:$AX$3 > > Series 2 > Values: ='Dollar Forecast'!$C$33:$AX$33 > Category (X) asix labels: ='Dollar Forecast'!$C$3:$AX$3 > > Based on the above information, my chart should start on October 5. > However, it insists on starting on August 2 although my data does not go > back > that far. I have change the scale information to start on 10/5, but it > keep > reverting to 08/02. Any ideas what may be causing this? I use Excel > 2003. > > Thanks in advance for your help. Happy Holidays! > Johnnie >

Re: Date Range Malfunction "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/23/2008 3:56:34 PM Is it a line chart or an XY chart? Is the data continuously increasing over the range $C$3:$AX$3? Make sure you didn't enter an incorrect date somewhere in the middle. Also when you set your new axis scale parameters, and change what's in the text box, do you then check the Auto checkbox in front? (Don't be insulted, I've seen this happen more times than you'd imagine). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Johnnie" <jdelariva[ at ]rbccorp.com> wrote in message news:49BCD8F9-A3FA-4325-ADB8-ED82EE4CF4A4[ at ]microsoft.com... [Quoted Text] >I have created a chart starting from scratch and using the wizard and I >still > can not get to work right. This is what I have entered > > Data Range: > ='Dollar Forecast'!$A$3,'Dollar Forecast'!$C$3:$AX$3,'Dollar > Forecast'!$A$31,'Dollar Forecast'!$C$31:$AX$31,'Dollar > Forecast'!$A$33,'Dollar Forecast'!$C$33:$AX$33 > > Series 1 > Values: ='Dollar Forecast'!$C$31:$AX$31 > Category (X) axis labels: ='Dollar Forecast'!$C$3:$AX$3 > > Series 2 > Values: ='Dollar Forecast'!$C$33:$AX$33 > Category (X) asix labels: ='Dollar Forecast'!$C$3:$AX$3 > > Based on the above information, my chart should start on October 5. > However, it insists on starting on August 2 although my data does not go > back > that far. I have change the scale information to start on 10/5, but it > keep > reverting to 08/02. Any ideas what may be causing this? I use Excel > 2003. > > Thanks in advance for your help. Happy Holidays! > Johnnie >