I have several worksheets that have a value located in the same cell on each

worksheet. I would like to graph these values.

Each worksheet is a monthly summary of activity for an event. Each

worksheet includes simple average and sum calculations, and it is the value

of the sum on each worksheet that I want to graph. To complicate this, I

would liek to set it up so tht I can insert a new worksheet into the set and

have it's number automatcially added to the graph.

I've looked at ranges and it looks promising, but everythimg I try to define

a graph data source I get an error that says something like "Reference is not

valid"

The data range I am attempting to use is: ='1:3'!$E$41

Any suggestions or comments about what I am doing wrong?

-Michael

## Bookmarks