6

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?

Improve this question
2
  • 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, 2017 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, 2017 at 21:43

1 Answer 1

Reset to default
1

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.

Improve this answer

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