3D Chart References

[william1034]

I have my budget set up in 12 worksheets, each worksheet has totals for
each friday in the month. I want to do a chart that shows each weeks
total across the whole year. Excel does fine with everything in one
worksheet, no matter what I try excel tells me I have an invalid
reference when I attempt to span work sheets. Any ideas?


Example: Assume week 1 thru 4 are in Jan. and 5-8 are Feb

X X
X X X X X
X X X X X X X
X X X X X X X X
Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7 Wk8