Working across worksheets

[paulkaye]

I've found a lot of posts about problems doing various actions across
worksheets but can't find any general information on this. Does anyone
know of a resource or could anyone provide a summary of what is and is
not possible to do across worksheets? Specifically:

Calculations across worksheets
Charting across worksheets (inc series across worksheets)

Effectively I have 3D data that I want to plot:

Individual expenses
Categories
Months

I want to list individual expenses in a particular category in the
column for that category. I then want to be able to compare that
column with the same column for different months (on different
worksheets). This seems like an elementary thing for Excel to do but
the posts I've read suggest otherwise. Could someone help me please?!

 

[Bernard Liengme]

Formulas such as
=AVERAGE(Sheet2:Sheet12!A1)
=SUM(Sheet2:Sheet12!A1:A12)
=SUM('Jan 06ec 06'!A1:A12) 'single quote needed when
sheet names have spaces

With chart:
Source Data
y-values: Sheet2!B1:B12
x-values: Sheet2!A1:A12


Tell us what you have tried and had trouble with
best wishes

 

[paulkaye]

Formulas such as
=AVERAGE(Sheet2:Sheet12!A1)
=SUM(Sheet2:Sheet12!A1:A12)
=SUM('Jan 06ec 06'!A1:A12) 'single quote needed when
sheet names have spaces

With chart:
Source Data
y-values: Sheet2!B1:B12
x-values: Sheet2!A1:A12

Tell us what you have tried and had trouble with
best wishes

Thank you for that summary. I have not begun the project yet but
wanted to check I would be able to do what I intend before I started!
If my memory serves me correctly, my concerns stem from a problem I
had when charting a series across worksheets. If and when I get stuck
again you can be sure I'll be back!
Thanks again,
Paul