3

When I copy and paste a graph in Google Docs, it makes 2 graphs, linked to the same spreadsheet. I'm looking to make 100 identically-styled graphs and quickly modify each one by editing the data in each.

Any idea how to duplicate the source table, so that I can modify each one independently?

  • If you create a bunch of charts in the spreadsheet (which can be done with a script), and edit data there, it's possible to insert all of them in a Google Document as static images (described here). But to my knowledge, one cannot programmatically create an actual chart in Google Documents. – user135384 Oct 27 '17 at 21:41
  • @Desire it doesn't need to be programmatic. I just want to copy and paste an existing chart the I inserted into a Google Doc, and use the same style to make another. – User Oct 27 '17 at 21:43
0

I was able to solve this problem. As long as all of your sheets are formatted the same (column headers and data all in the same place) it should work. Copy the chart and paste it into the new sheet. Click on Edit Sheet. Under Data Range it should have something like Sheet1!A1:B5. Just change the sheet number to match the sheet you pasted the chart into. Sheet 2 should read Sheet2!A1:B5, 3 should read Sheet3!A1:B5, and on from there.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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