=SERIES(Name_ref,Categories, Values, Plot_Order)

Help with the Name_ref looks like what I most need, as the chart
references what looks like a named range, but I can't find it.


I inherited a spreadsheet (Excel '97)tracking "Days to Assign." When a
software defect is reported (April 1, 2007, for example) and it's
assigned to a tester, this chart shows the days it took to assign the
defects.

Pretty simple.

However, I cannot figure out the SERIES function. I looked up the
syntax, and it looks straight forward.


Ex:
I copied and pasted this from the chart where I clicked on a data
point.

=SERIES("Qtr 1 07",'Report Data'!$N$2:$N$31,'Report
Data'!$P$2:$P$31,1)

Column N - Y Axis (not sure what's meant by "Plot Order")

Column P - Assigned (#days it took to assign the issue)

Problem:
I cannot find the referenced "Qtr 1 07" in the worksheet "Report
Data". I looked by going to the name bar, but as far as I can tell,
there are no named ranges. Is "Qtr 1 07', actually I see no ranges at
all.

I looked in all worksheets, but only two have data, and the other 5
are graphs that I'm supposed to update, but since the previous guy
left and nobody I have access to knows that much about Excel, I'm
supposed to figure it out :)

Any help would be appreciated. I think I'm in over my head.

Thanks, very much.

George