Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation malfunction | Excel Discussion (Misc queries) | |||
Help Excel malfunction | Excel Discussion (Misc queries) | |||
pPMT malfunction | Excel Worksheet Functions | |||
AutoSum malfunction | Charts and Charting in Excel | |||
worksheet malfunction | Excel Worksheet Functions |