0
Right click on the embedded chart and choose 'location'.
Click radio button next to 'As new sheet' then click OK.
Al
select CHART TOOLS DESIGN TAB, then click MOVE CHART LOCATION
Wiki User
∙ 8y ago
Wiki User
∙ 6y agoOn the same worksheet, you can cut and paste it or drag it to a new location. If you want to move it to another worksheet in the same workbook, again you can copy and paste, and on the Design tab of the Chart tools, you have the option to move the selected chart.
Wiki User
∙ 11y agoRight-click on the chart
- then either Cut or Copy
and Paste in other worksheet
Add your answer:
Earn +20 pts
In Excel what is the default name for a worksheet when a chart on Sheet1 is moved to a new sheet?
If it is moved to be a chart on its own, that is known as a Chart Sheet, not a worksheet, and its name will be Chart1. A Chart sheet, unlike a worksheet, just has a chart and has no cells. Moving a chart from a worksheet will not affect that worksheet's name. So in this case, it would still be Sheet1. If you move a chart to another worksheet, embedding it there, that does not affect the name of that worksheet. So it could b embedded on Sheet2 or Sheet3 or whatever name may have been given to it.
How is a chart moved on a worksheet?
Click Design , and then click Move Chart.
How do you move a worksheet in Excel 2007?
The question is not clear, but if you have several worksheets in an Excel 2007 workbook, you can move a worksheet to a new location in the workbook by clicking and dragging the worksheet tab to the loction you want.
What does clicking and dragging top of chart do in Excel?
It allows you to move the chart. Depending on where you click exactly, you can pick up the chart and then drag it to a new location. This only works if you are in an embedded chart. It does not do anything on a chart sheet. You can also move the plot area within the chart area on both an embedded chart or a chart on a chart sheet, when you click at the top or on any part on the plot area.
What is the function of the MS Excel vertical scrollbar?
It enables you to move up and down the worksheet.
Where can the button be found to move a chart to a new sheet in an Excel workbook?
It is in the Chart Tools Design tab. You need to click on the Move Chart Location tab.select the chart in excel, then we get DESIGN menu in menu bar, then click that DESIGN menu, then we get options present in that design menu.In that options at the right side top of the window we can see "MOVE CHART" then click that and give location where u want to move the chart.
Explode Excel worksheets into separate Excel workbooks?
If your Excel workbook has several worksheets and you want to save them into separate Excel workbooks, try the following: Position your mouse on the worksheet tab (bottom left of the screen). Right mouse click on the worksheet tab and select "Move or copy" from the shortcut menu. This opens the Move or Copy dialog box. In the "To book:" field, choose "(new book)"Click the check box for Create a copy if you want to keep the worksheet in the original workbook, or leave it unchecked if you want to move the worksheet from the original workbook. Click OK to finish the steps.
What is the use of move or copy sheet tab in Microsoft Excel?
If you have two workbooks and want to move a worksheet from one to the other, you would use the move option. If you want to copy the worksheet so that it is in both workbooks, you would use the copy option.
How do you copy Excel charts into word 2003?
Open Excel and right-click on the chart and select copy. Go to Word and paste the chart where you would like to see it on the page, then move the object, as desired.
What is the result of pushing the END key within an Excel worksheet?
It turns the End mode on. When you then press one of the arrow keys it will move to the end of the current block of data if you are in a block, or to the start of the next block of data if you are not in a block.
What are disadvantages of embedded charts?
They don't always look as good, as they are floating over the data. They don't have fixed positions, so it can be harder to find them on a large sheet. You often have to move them as you add more data into the worksheet. It is more difficult to manipulate an embedded chart that a chart sheet. They are usually small, so don't always give a good representation of the data.
What key do you use on the keyboard to navigate a worksheet?
The F5 key is used on the keyboard to navigate a worksheet in Microsoft Excel. This allows you to use the "Go To" feature and move around the various cells on the sheet.
