Charting data from multiple sheets

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?

Sean -

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Sean Mc wrote:
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,
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

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Wayne wrote:
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