Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    61

    Unanswered: How can I chart Multiple sheets?

    Hello to all,

    Anyone know how to chart multiple sheets in the same workbook?

    I know to chart a single sheet such as =Sheet1!R1C1:R1C6
    but what I want to chart is a single field through multiple sheets and I can't figure out how to do this. such as charting field r1c1 on sheets1:sheets27

    Any help is greatly appreciated.

    Mythos.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    In Source data, you would have to identify each point separately.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •