Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gdareos - 22 Mar 2008 21:23 GMT
=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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.