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.
Example spreadsheet
Published spreadsheet
What am I doing wrong?
-
currently only 18 views. cross posted to productforums.google.com/d/topic/drive/s20Z9o6NMPA/discussion– antony.trupeOct 2, 2012 at 14:57
-
36 views as of 2012-10-25– antony.trupeOct 25, 2012 at 14:55
-
100 views! 0 answers :(– antony.trupeJan 16, 2013 at 4:06
-
I guess you're not doing anything wrong. In your file, I added the sheet range of sheet 1, via the ARRAYFORMULA, changed the chart, published and was able to see the chart. Apparently, it's not possible, +1 for waiting !!– Jacob Jan TuinstraFeb 15, 2013 at 22:54
-
190 views! 0 answers :(– antony.trupeMay 10, 2013 at 14:42
|
Show 1 more comment
1 Answer
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!
