How Do I Move A Chart To An Object In Excel

Then click the design tab of the chart tools contextual tab in the ribbon.

How do i move a chart to an object in excel. To move the chart as an object in another worksheet click object in and then in the object in box select the worksheet in which you want to place the chart. Select the chart which you want to move and go to design tab click move chart button which is in location group. If you just want to move the chart as an object to an existing worksheet of current workbook please select the object in option specify a worksheet in the drop down list and finally click the ok button.

After clicking the ok button the chart will be moved to the sheet as you want. To begin head over to design tab and click move chart. To move a chart in excel to make it the only object in its own worksheet or to move the chart to a different worksheet but still have it remain as an embedded chart select the chart area.

Its dialog will appear now enable object in option and select the worksheet from the list. You clicked on a chart object tried to move it just a little bit to the right by pressing right arrow key a few times instead of the chart being moved to right different chart elements were selected one by one with each press of the arrow key. Do one of the following.

When move chart dialog box appears type a new name of worksheet in the box of new sheet and click ok in the bottom. If you want to move the chart to a new chart sheet please check the new sheet option enter a sheet name and click the ok button. To move the chart to a new worksheet click new sheet and then in the new sheet box type a name for the worksheet.

Then click the move chart button in the location button group.