I can successfully include a chart based on a single sheet, but as soon as I combine ranges from multiple sheets, I get an access denied error.
What am I doing wrong?
migrated from superuser.com Sep 28 '12 at 6:34
This question came from our site for computer enthusiasts and power users.
I know it's late, but I figure this will be useful for future searchers.
The answer seems to be that you need to create an intermediate sheet with both sets of values. The intermediate sheet ("combined data") has two cells with formulas:
The chart uses the following as its data:
I have created a spreadsheet for you to look at:
ps - just as it hits 300 views!