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:
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?
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.
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.