0

I have a Google spreadsheet that contains charts which are properly displayed. When I am using a GAS to copy these charts to a Google document some of the charts are properly displayed in the document while others (which are displayed properly in the spreadsheet) are displaying the message "All series on a given axis must be of the same data type".

Since these are working charts I am not sure why I get this message. Is there a workaround to this problem or a known issue?

Any advise will help.

Thx!

Alan Wells
  • 30,746
  • 15
  • 104
  • 152
theworldismyoyster
  • 561
  • 1
  • 6
  • 18
  • 1
    You can refer to these questions. http://stackoverflow.com/questions/13216377/google-chart-api-error-all-series-on-a-given-axis-must-be-of-the-same-data-type http://stackoverflow.com/questions/22476299/all-series-on-a-given-axis-must-be-of-the-same-data-type – KRR Jan 02 '15 at 19:11
  • KRR, this helped solve problems on several levels. Much appreciated! – theworldismyoyster Jan 05 '15 at 11:46

1 Answers1

0

Based on KRR answer. Even though the chart might be working in Google spreadsheet it appears that the getBlob of the chart rechecks the source values of the chart. You need to make sure that the source values (in my case above from a spreadsheet) all have the same data type.

theworldismyoyster
  • 561
  • 1
  • 6
  • 18