USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How do you move a chart to a separate worksheet?
|
|
Go to the Page Layout tab, click Move Chart button, click New sheet box, and add the name.
|
|
|
Drag the chart to the new sheet tab.
|
|
|
Go to the Insert tab, click New Chart, and add the name.
|
|
|
Go to the Design tab, click the Move Chart button, click New sheet box, and add the name.
|
Explanation:
Detailed explanation-1: -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: -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”.
There is 1 question to complete.