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???


"Jon Peltier" wrote:

http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tia" wrote in message
...
I have an excel file that has the following worksheets.

Jan 4
Feb 5
March 6
June 7
July 6

They each have data in the cell G15. I need the data from each of those
cells plotted on the same chart. We've been using Lotus and it was super
simple. I'm at a loss how to do the same thing in Excel.

Thanks to anyone who can answer this question!!