Charting data from multiple sheets

  • Thread starter Thread starter Sean Mc
  • Start date Start date
S

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?
 
Sean -

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

- Jon
 
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
 
Back
Top