Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question

migrated from superuser.com Sep 28 '12 at 6:34

This question came from our site for computer enthusiasts and power users.

    
currently only 18 views. cross posted to productforums.google.com/d/topic/drive/s20Z9o6NMPA/discussion –  antony.trupe Oct 2 '12 at 14:57
    
36 views as of 2012-10-25 –  antony.trupe Oct 25 '12 at 14:55
    
100 views! 0 answers :( –  antony.trupe Jan 16 '13 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 Tuinstra Feb 15 '13 at 22:54
    
190 views! 0 answers :( –  antony.trupe May 10 '13 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:

Multisheet chart spreadsheet

and a published chart

ps - just as it hits 300 views!

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.