You can use formulas to compile the values onto a single sheet:
http://peltiertech.com/Excel/ChartsH...iffSheets.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
SteW wrote:
I'm having trouble creating a graph because the data is spread on different
sheets.
I've got a new sheet for each month and I'd like to produce a trend graph.
Do I have to bring each set of numbers onto the same sheet, or is there a way
to have a range of data spread over various sheets?
I hope that makes sense!