Charting data from multiple sheets

[Sean Mc]

Is there a way to chart date from multiple sheets. I have
used Qpro for years and want to get away form it but... I
use one sheet per month of data and what to chart Jan to
Dec for example. Any ideas?

 

[Jon Peltier]

Sean -

You need to summarize the data on a single sheet, then make your chart.
You can use formulas to do this.

- Jon

 

[Wayne]

Jon,
You mentioned that to chart data from multiple worksheets
you have to summarize the data on one worksheet using
formulas. Can you point me in the right direction as to
which formulas to look at?

Thank you,
Wayne

 

[Jon Peltier]

Wayne -

Suppose I wanted the value from cell A1 of each sheet. In my summary
sheet, I put the sheet names in A5, A6, A7. In B5 I put the formula
=INDIRECT(A5&"!A1"), and I filled this down to B7. The formula builds a
string containing the value of cell A5 plus the stuff in quotes, or
Sheet1!A1, and the indirect evaluates the string, and returns the value
in the cell it references.

I can now use the range B5:B7 of my summary sheet to chart Sheet1:Sheet3!A1.

- Jon