Charting one cell from multiple sheets

E

erriac

I have a workbook with 66 sheets. Each sheet represents a different day and
is named ie. 12-7-08, 12-8-08, etc. I am trying to chart one cell (f40) from
each sheet into one chart to track the change of an account balance day to
day. I have reviewed the similar questions in this forum and have tried each
suggestion to no avail. Is it because the sheets are named with dates? Can
anyone help me not have to enter ='12-7-08 '!F40, etc, etc....66 times?
Thank you in advance.
 
S

Shane Devenshire

Hi,

On the sheet where you want the chart enter the dates in the first column

12-7-08
12-7-09
....

Suppose these are in A1:A66, and suppose the entries you want are in F40 on
each sheet, then enter

=INDIRECT("'"&TEXT(A1,"m-d-yy")&"'!F40")

In B1 and copy it down. Be very careful toi include the ' (two single
quotes - one after the (" and one before the !F40)
Use this range to plot your chart.


If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Line charting the same series using data from multiple sheets? 1
Summary from multiple sheets 1
auto date changing on worksheets 8
Merge Multiple workbook sheets into one workbook 0
Sheets Name 1
Naming sheets from a cell value 12
Automate sheets list 1
Pulling one cell from Multiple sheets to one sheet 2

Top