Page 536 - Excel 2013 All-in-One For Dummies

518 Worksheet Charting 101
Moving an embedded chart onto its own chart sheet
If it’s really important that the chart remain a separate element in the workbook, you can move the embedded chart onto its own chart sheet. Simply click the embedded chart if it’s not already selected in the worksheet and then click the Move Chart command button in the
Location group on the Design tab of the Chart Tools contextual tab on the Ribbon. Excel then opens the Move dialog box, where you then click the New Sheet option button and click OK to switch the embedded chart to a chart on a separate chart sheet.
Embedded charts versus charts on separate chart sheets
An embedded chart is a chart that appears right within the worksheet (like the one shown in Figure 1-1) so that when you save or print the worksheet, you save or print the chart along with it. Note that your charts don’t have to be embedded. You can also choose to create a chart in its own chart sheet in the workbook at the time you create it. Embed a chart on the work- sheet when you want to be able to print the chart along with its supporting worksheet data. Place a chart on its own sheet when you intend to print the charts of the worksheet data separately.
Keep in mind that all charts (embedded or on their own sheets) are dynami- cally linked to the worksheet that they represent. This means that if you modify any of the values that are plotted in the chart, Excel immediately redraws the chart to reflect the change, assuming that the worksheet still uses automatic recalculation. When Manual recalculation is turned on, you must remember to press F9 or click the Calc Now (F9) command button on the Formulas tab of the Ribbon (Alt+MB) in order to get Excel to redraw the chart to reflect any changes to the worksheet values it represents.
You can print any chart that you’ve embedded in a worksheet by itself with- out any worksheet data (as though it were created on its own chart sheet) by selecting it before you open the Print dialog box.
Inserting recommended charts
My personal favorite way to create a new embedded chart from selected data in a worksheet in Excel 2013 is with the new Recommended Charts command button on the Insert tab of the Ribbon (Alt+NR).