Step 1: Select the chart that you want to move. Open the Design tab under Chart Tools on the Excel ribbon. (Click the image below for a larger view.)
click to enlarge
Step 2: Click on the Move Chart button.
click to enlarge
Step 3: In the Move Chart window that appears, you will have two options. You can either move the chart to an existing spreadsheet listed in the dropdown box located next to Object in, or you can create an entirely new worksheet by choosing the New Sheet option.
click to enlarge
If you choose to move the chart to an existing spreadsheet, it will maintain the same size as it has in the current sheet. However, if you choose to create a new worksheet to place the object in, the chart will take up the full worksheet. This latter option is usually the best selection if you want to display the chart in a slide or as some other major exhibit in another Microsoft Office application.
Step 4: Click OK to continue. The chart will now appear in the designated worksheet. In this example, we picked the New Sheet option in Step 3, and the results are shown in the screenshot below.
click to enlarge
Tip: If you pick the option to move the chart to a new worksheet, the chart will be resized to fit the visible space in that sheet. As a result, some of your formatting, such as font size, may no longer have the desired visual effect you were trying to achieve. You can modify the formatting in this “full screen” sheet in the same manner you would any other worksheet. Select the chart and the tabs under Chart Tools will appear in the Excel ribbon, ready for use.
For more tips and tricks, be sure to browse through the other Microsoft Excel tutorials found here on Bright Hub's Windows Channel.
