On Wed, 9 May 2007, in microsoft.public.excel.charting,
Tia said:
I've tried this and I'm still not getting the result I need. Here's what I
used for the formula:

=SERIES(Jan 4!$A$15:$G$15, Feb 5!$A$15:$G$15, March 6$A$15:$G$15, June
7$A$15:$G$15, July 5$A$15:$G$15)

Is there a simpler way to get all the sheets?? In Lotus, I could just type
Jan 4:G15...July5:G15....Then all worksheets between those would be graphed
on chart. Does Excel have something similar???

Lotus 123 was in many ways superior to Excel even today. One of those
ways was that it had genuine 3D spreadsheet capability that Excel only
ever faked clumsily by having separate 2D spreadsheets.

I suggest that, as Jon says, you create a separate summary sheet, and in
that sheet create a function that uses INDIRECT to read the contents of
cells that you populate, and go to the cell indicated by those cells.
For instance

=INDIRECT("'"&"Jan 4"&"!A15"&"'")

will return the contents of cell 'Jan 4!A15', by concatenating the text
values "'", "Jan 4", "!A15" and "'". I hope you can easily see how to
build a 2D table that has "Jan 4", "!A15", as row and column headings.
You can then create a chart from that table.

(By the way, all the palaver with " ' " is made necessary by your use of
spaces in the sheet names. Eliminate the spaces and you should be able
to get away with not using them)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.