How Do I Move A Chart To An Object In Excel
Here i d like to give a simple guide of how to move a chart in microsoft excel.
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. 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.
Then click the move chart button in the location button group. After clicking the ok button the chart will be moved to the sheet as you want. To move the chart to a new worksheet click new sheet and then in the new sheet box type a name for the worksheet.
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. If you do chart in excel you may have encountered this. 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 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. 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.
Select the chart which you want to move and go to design tab click move chart button which is in location group.