Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charting one cell from multiple sheets
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charting one cell from multiple sheets
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 "erriac" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charting one cell from multiple sheets
That worked great. Thank you very much for your help.
"Shane Devenshire" wrote: 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 "erriac" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add (=Sum) the same cell for multiple sheets (103) | Excel Worksheet Functions | |||
quick charting question for similar charts on multiple sheets | Charts and Charting in Excel | |||
in charting, how do i select data ranges from multiple sheets, sa. | Charts and Charting in Excel | |||
Charting series in different sheets (summarize) | Charts and Charting in Excel | |||
same cell from multiple sheets into one column | Excel Discussion (Misc queries) |