Excel - Charts - named range ref in SERIES() - Can't find it

Asked By Gdareos on 22-Mar-08 04:23 PM
=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




BarbReinhard replied on 22-Mar-08 06:27 PM
The Name_Ref is either a test string or a reference to a cell containing a
string that describes the series.  That's all it is.   Someone may have typed
in Qtr 1 for the Name_ref.  I do it all the time.

Take a look here to get more info on Excel Charts.

http://www.peltiertech.com/Excel/ChartsHowTo/index.html
--
HTH,
Barb Reinhardt
Gdareos replied on 23-Mar-08 11:18 AM
I really got distracted by this. I was thinking it was a named range
of cells in one of the worksheets (embarrassed).

I appreciate the help!

The link you supplied is MUCH more informative than what I've seen
elsewhere.

Thanks,
Louis



On Sat, 22 Mar 2008 15:27:01 -0700, Barb Reinhardt