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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
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:
A1 =ARRAYFORMULA(Sheet1!A:C) D1 =ARRAYFORMULA(Sheet2!A:C)
The chart uses the following as its data:
'combined data'!D1:E14, 'combined data'!B1:B8
I have created a spreadsheet for you to look at:
ps - just as it hits 300 views!