=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
Barb Reinhardt - 22 Mar 2008 23:27 GMT
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

Signature
HTH,
Barb Reinhardt
> =SERIES(Name_ref,Categories, Values, Plot_Order)
>
[quoted text clipped - 38 lines]
>
> George
Gdareos - 23 Mar 2008 16:18 GMT
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
>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
[quoted text clipped - 3 lines]
>
>http://www.peltiertech.com/Excel/ChartsHowTo/index.html