FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Move a chart to another worksheet Click anywhere in the chart. Under Chart Tools, on the Design tab, in the Location group, click Move Chart. Do one of the following: To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet.

Detailed explanation-2: -Chart tools comprise of two tabs DESIGN and FORMAT. Step 1 − When you click on a chart, CHART TOOLS comprising of DESIGN and FORMAT tabs appear on the Ribbon. Step 2 − Click the DESIGN tab on the Ribbon.

Detailed explanation-3: -At first, create a new worksheet where you want to move all charts. Then, open a worksheet and pitch on a chart in it. Next, right click on the chart and select “Move Chart” from the context menu. In the popup “Move Chart” dialog box, select the new sheet in “Object in” list and click “OK”.