Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Charting Data from Different Worksheets

Posted by Rick on March 28, 2001 6:53 AM

Here is what I am trying to accomplish but can't seem
to find a way to do it. I have 1 Excel file with 31
different sheets in it (1 for each day of the month)
One of the values on each sheet for example is the #
of Fat grams consumed that day. What I want to do at
the end of the month is to be able to have the total
averages for the month and chart them. For example,
35 Fat grams on average per day in February 2001.
Any Ideas?

Thanks Very Much in Advance!!

Re: Charting Data from Different Worksheets

Posted by mseyf on March 28, 2001 10:35 AM

Rick-

the syntax for refering to another sheet would be:

=SheetName!CellReference (note exclamation point)

so your list of data would look something like

=sheet1!A1
=sheet2!A1
=sheet3!A1
=sheet3!A1
etc.

HTH

Mark

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.