LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add (=Sum) the same cell for multiple sheets (103) How do I sum sheets Excel Worksheet Functions 2 April 24th 06 06:43 PM
quick charting question for similar charts on multiple sheets Boon8888 Charts and Charting in Excel 2 January 27th 06 07:33 PM
in charting, how do i select data ranges from multiple sheets, sa. michael Charts and Charting in Excel 1 March 6th 05 03:01 PM
Charting series in different sheets (summarize) uriel78 Charts and Charting in Excel 2 February 23rd 05 01:44 PM
same cell from multiple sheets into one column Kel Excel Discussion (Misc queries) 0 February 18th 05 12:53 AM


All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"