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 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. Do one of the following. If you do chart in excel you may have encountered this.
Here i d like to give a simple guide of how to move a chart in microsoft excel. 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 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. 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.
Then click the design tab of the chart tools contextual tab in the ribbon. 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 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.
Click ok to move the chart as object in the specified sheet.