Double click on the chart that you want to edit, to open the chart editor. To change the data range of a chart in Google Sheets, follow these steps: In this example, we want the new / duplicated chart to be connected to the "Product Sales 2" data, in rows 9 through 15 (Where the original chart is connected to rows 1 through 7). You will probably want your new chart to be connected to a different data set, and so we will need to change the "Data range" of our new chart. But there are modifications that we need to make to the new chart now. Note that the chart style / formatting will be the same as the original, and by default the duplicate will be connected to the same source data / data range as the originalĪs mentioned above, if you want, instead of pressing Ctrl + C on the keyboard to copy the chart, you can use the "Copy chart" menu option as shown in the image below.Īfter following the steps above, you will have two copies of the same chart, as shown below. Press Ctrl + V on the keyboard to paste a duplicate of the original chart. Press Ctrl + C on the keyboard to copy the chart, or click the three dots in the upper right corner to open the chart menu, and then click "Copy chart". Click on the chart that you want to duplicate. To duplicate a chart in Google Sheets follow these steps: We will do this by copying and pasting the chart to duplicate it. We are going to copy the chart style to another chart by duplicating the chart, and connecting the new chart to a different set of data. In the example image below, the stacked column chart is connected to the "Product Sales 1" data in rows 1 through 7. After duplicating the chart you can change the data range and make any additional modifications that are needed. 
You can easily copy the style of one chart to another in Google Sheets by simply duplicating the chart that you have already formatted.
YOUTUBE T CHART GOGLE DOCS HOW TO
How to copy chart style / duplicate charts in Google Sheets For the examples we will use a stacked column chart that has already been formatted just the way that we want it.Ĭheck out this lesson on creating charts to learn all about creating charts / graphs in Google Sheets, including how to format your data for each different chart. This process is explained in the detailed examples below. Optional: Adjust additional options such as chart title, etc.Īfter following the steps above you will have a new chart with the same formatting as the original, but you will be able to connect it to new data and make additional changes to it without having to format the entire thing all over again.In the chart editor, change the "Data range" so that your new chart is connected to the correct data.Press Ctrl + V on the keyboard to paste / duplicate the chart into the new location.Click the tab / cell where you want to place your new chart.Press Ctrl + C on the keyboard to copy the chart.Click once on the chart, to select the chart that has formatting that you want to copy.To copy chart style / formatting in Google Sheets, follow these steps: The trick is to simply duplicate the chart that you have already formatted, and to change the data range of the new chart. In this lesson I am going to show you how to do exactly that. Do you have a chart that you have already formatted, and want to copy the formatting from that chart to another chart? Or perhaps you simply want to know how to duplicate charts.
0 kommentar(er)
