How Do I Move A Chart To An Object In Excel
To begin head over to design tab and click move chart.
How do i move a chart to an object in excel. To move the chart to a new worksheet click new sheet and then in the new sheet box type a name for the worksheet. Here i d like to give a simple guide of how to move a chart in microsoft excel. Its dialog will appear now enable object in option and select the worksheet from the list.
Then click the design tab of the chart tools contextual tab in the ribbon. Click ok to move the chart as object in the specified sheet. 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.
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.
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. If you do chart in excel you may have encountered this. 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 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.