You can copy a chart. For example, you may want to copy a chart from one worksheet to another. Scroll the mouse over the chart you want to copy that shows up as Chart Area, then you can hold the control button and click on the chart area to select copy or copy per your preferred method.
Another example: you might copy a chart and then select new or different data for the second version of the chart. This can be especially useful if you want the titles, axis labels, or the appearance of the series to be the same if you had already taken the time to format them.
In this case you can copy the chart and reselct your data. (Recall how to select data)
You can also cut a chart. Scroll the mouse over the chart you want to copy that shows up as Chart Area, then you can hold the control button and click on the chart area to select cut or cut per your preferred method.
Select the cell that you would like to place the top left corner of the chart, and then paste per your preferred method.
Of course, you can also move a chart with your mouse.
You can also use Copy to copy the information from one chart into another chart. For example, let's say I wanted to make a chart of the change between 2000 and 2010:
Notice that I chose data points that line up with the horizontal axis.
I went to Select Data and changed the name of the series and the labels on the horizontal axis.
I shifted the horizontal to Low so that it would be below the plot area.
Of course, I would also like to resize the plot area and move the legend around differently, or delete it entirely since there is only one series, but I really wanted to show you how to copy and pasted the data from the new chart into the old chart. So let's get to it!
Copy the new chart (you can also cut if you want to completely remove the chart). Then select our original chart and paste.
You'll notice the top chart now has a third series (Difference). The axes were automatically reformatted by Excel to account for the additional data points.
It is important to think about why you might combine series or different data sets within a single graph. Ask yourself things like:
What exactly is the graph presenting?
How can we interpret that information?
Does it help explain or clarifiy the results?
Thinking about these questions, do you think it is appropriate to merge the two graphs as we've done? If you're not sure, send us an email or drop in during our open lab hours (see below).