stapuff
01-06-2005, 09:55 AM
I am trying to create a line chart with no luck.
My range is sheet1!$X$1:$AB:21
X1 = Date
Y1 = Ord. Qty
Z1 = Prod Date
AA1 = Expected
AB1 = F/G Inv.
$X$2:$X$21 (Date Values) to be the X Axis
0-10000 in 500 Increments to be the Y axis
$Y$2:$Y$21,needs to be a line on the chart dependant on date from column X
$AA$2:$AA$21 & $AB$2:$AB$21 needs to be lines on the chart dependant on the date from column Z.
The basic idea is column X is my customer order date & column Y is the quantity they are ordering based on the date in column X.
Column Z is the date I need to start producing on. Column AA is what I expect to produce & Column AB is what was produced minus customer orders.
I would only like to see the dates from column X and Column AA & AB?s values chated against X?s dates.
Any help would be greatly appreciated.
Thanks,
Kurt
My range is sheet1!$X$1:$AB:21
X1 = Date
Y1 = Ord. Qty
Z1 = Prod Date
AA1 = Expected
AB1 = F/G Inv.
$X$2:$X$21 (Date Values) to be the X Axis
0-10000 in 500 Increments to be the Y axis
$Y$2:$Y$21,needs to be a line on the chart dependant on date from column X
$AA$2:$AA$21 & $AB$2:$AB$21 needs to be lines on the chart dependant on the date from column Z.
The basic idea is column X is my customer order date & column Y is the quantity they are ordering based on the date in column X.
Column Z is the date I need to start producing on. Column AA is what I expect to produce & Column AB is what was produced minus customer orders.
I would only like to see the dates from column X and Column AA & AB?s values chated against X?s dates.
Any help would be greatly appreciated.
Thanks,
Kurt