=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
However, I cannot figure out the SERIES function. I looked up the
syntax, and it looks straight forward.
I copied and pasted this from the chart where I clicked on a data
=SERIES("Qtr 1 07",'Report Data'!$N$2:$N$31,'Report
Column N - Y Axis (not sure what's meant by "Plot Order")
Column P - Assigned (#days it took to assign the issue)
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
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.