Sleeper: Line Chart Help Needed

[stapuff]

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

[cyrilbrd]

Hi,
Will F/G Inv. always be a positive value?
F/G Inv. = Expected - Ord. Qty right?
then you wish to graph Expected and F/G inv. versus Date (ColumnX)
and Ord. Qty versus Date
So are those two graphs or just one graph?
Have you tried to plt F/G Inv. on the secondary axis since it is smaller than Expected?