Skip to main content
Matik Help Center home page Help Center
Matik Blog Case Studies
  1. Matik
  2. FAQ and Troubleshooting
  3. Common Errors

Error: There was an error updating the chart. Google returned 400: Requested writing within range (Cell Range), but tried writing to column(column letter)

This article is related to the following error message:

  • Error: There was an error updating the chart. Google returned 400: Requested writing within range (Cell Range), but tried writing to column(column letter)
  • Example message:
              • mceclip2.png

Cause 1

This error message occurs when dynamic content produces extra columns that are not included in a chart. The number of columns returned by your dynamic content must equal the number of columns your chart will use. Any additional data columns will result in this error being returned.

For example, let's say I have the following chart in a template:

mceclip2.png
The source data looks like the following: (Click into the menu in the upper right of the chart and click "Open Source" to access)
mceclip4.png

Note the Series included in the chart. If our dynamic content returns a "Period 3" column of data in column D this error will appear. The number of columns returned by your dynamic content must be equal to the number of columns your chart is configured to use.

To resolve this issue, we simply add a 3rd Series of data to the chart with our Period 3 data.
mceclip5.png

 

Cause 2

This issue can also occur when "Use column A as labels" is not selected. Navigate to the chart editor as demonstrated above and scroll down to the bottom. Ensure "Use column A as labels" is selected.
mceclip0.png

Was this article helpful?

Have more questions? Submit a request

Related articles

  • Connecting to CRMs (Salesforce, Hubspot, Gainsight)
  • Error: TooManyRowsForChartError: There was an error populating the chart for <Dynamic Content Name>...
  • Tags Overview
  • Matik App for Salesforce Setup
  • How do I use an Input as Dynamic Content?

Articles in this section

  • How to view presentation generation errors
  • Error: TooManyRowsForChartError: There was an error populating the chart for <Dynamic Content Name>...
  • Error: There was an error updating the chart. Google returned 400: Requested writing within range (Cell Range), but tried writing to column(column letter)
  • Error: (Comparison Operator) not supported between instances of (type) and (type)
  • Error: Comparing None value: (logical comparison)
  • Error: Google had an internal error when copying a presentation to your Google Drive
  • Error: We couldn't check for the existence of the Custom Matik Presentations folder in your drive. Have you connected to Google?
  • Error: Divide by zero
  • Warning: Generated with errors: Column does not exist in return value

Comments

0 comments

Please sign in to leave a comment.

Personalize data-driven content in minutes

Product

  • How it Works
  • Security

Solutions

  • Sales
  • Customer Success
  • Ops & Strategy
  • Data

Resources

  • Blog
  • Case Studies
  • Help Center

Company

  • About Us
  • Careers
  • Terms of Service
  • Privacy Policy

© 2022 Matik, Inc.