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

You have to use that with a function. For instance, do you want SUM? Then do this:

=SUM('010606:011306'!$H$13)

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?

Can you attach a sample file?

Which point is it placing?

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

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.

Perhaps this explanation of Charting Data from Different Sheets by Jon Peltier might resolve the issue for 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.