Duplicate graphs with new data

[dannybten23]

I have about 100 sets of data, each set has 12 rows and 10 columns. I have build a graph for the first set of data. I need to duplicate that graph for the other 99 sets of data, but do not want to manually build each graph.
How do I copy the graph and paste it into a new location, with new data based on the graphs location. A copy and paste functions for graphs is really what I need.
Any help is greatly appreciated!!
Thank you,
Dan

 

[JoeMo]

Once you have created, formatted the first chart you can save it as a template (Select chart>Chart Tools>Design>Type>Save as Template) to use for the remaining charts. See this link to get started:

https://support.office.com/en-us/ar...template-505ba53b-41b1-49af-9886-5179640a14ae