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

    Question Unanswered: Source Data Values for chart not working

    Hello to All,

    I am having a problem with the Values field on my Source Data for my charts. I have a sheet for every friday with our weekly reports I then have a main sheet with the chart. I need to chart out one field from each sheet. This is the code the system entered which fails:
    ='010606:011306'!$H$13
    which is trying to use just the first two sheets. Sheet 010606 field H13 and sheet 011306 field H13. and this promts me that there is an error in the formula.

    How can I span multiples sheets using the same field on each sheet?

    All your help is greatly appreciated.

    Mythos

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    You have to use that with a function. For instance, do you want SUM? Then do this:

    =SUM('010606:011306'!$H$13)
    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

  3. #3
    Join Date
    Apr 2005
    Posts
    61

    But for a chart?

    This is what is used when using a row within the same sheet
    =Sheet1!$A$100:$AY$100

    and it places the point and and draws the graph on the chart for each value along the span given

    now I would like to pull another value from one field along a span of sheets.

    Any ideas?

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Can you attach a sample file?

    and it places the point
    Which point is it placing?
    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

  5. #5
    Join Date
    Apr 2005
    Posts
    61

    Ok here is my example

    Ok here it is. Right now I have to map over from each worksheet to the first sheet where the charts are located. You can view the source data for the chart and see how it's coded. The problem is I can't figure out how to have it span through worksheets instead so that I don't have to map to the first sheet then update the chart. I'd like to just tell the chart which field on each sheet. Now the fields will always be located in the same spot on each sheet.

    Hope you can figure it out. I'm at a loss.


    and thanks again.

    Mythos
    Attached Files Attached Files

  6. #6
    Join Date
    Oct 2003
    Posts
    1,091
    Initial look, it doesn't appear that you can do what you want. However, I have a couple of resources I will check over night and see what we can do.
    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

  7. #7
    Join Date
    Oct 2003
    Posts
    1,091
    Perhaps this explanation of Charting Data from Different Sheets by Jon Peltier might resolve the issue for you.
    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

  8. #8
    Join Date
    Apr 2005
    Posts
    61

    Thank you

    I do thank you for your assistance. I will review the article. It looks familiar. I've tried to do this before but couldn't figure it out. I decided to try again which is what prompted this post. I'll let you know if I am ever able to make it work.

    Thanks again for your help it truely is appreciated.

Posting Permissions

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