You'll no longer receive security updates. You'll no longer receive Office 2007 software updates from Microsoft Update. If you paste the chart to a different workbook, it will be linked to the data in the original workbook.Tip: Not sure what version of Office you have? See Find details for other versions of Office to help you determine what version you're currently running. The new location can be in a different worksheet or even in a different workbook. Then activate a cell near the desired location and choose Home > Clipboard > Paste (or press Ctrl+V). Select the chart and choose Home > Clipboard > Cut (or press Ctrl+X). In fact, this is the only way move a chart from one worksheet to another. You also can use standard cut and paste techniques to move an embedded chart. Although this isn't as quick as dragging the chart edge, it lets you set the size exactly, which is indispensable if you have several charts on the same worksheet and you need to make sure they're all the same size.
You can set the Height and Width boxes in the Chart Tools: Format > Size section of the ribbon. When you're finished, click a cell anywhere in the worksheet to go back to your data.Īt this point, life returns to normal, and the Chart Tools tabs disappear.Using the two-way arrow, you can drag the border to make the chart larger or smaller. Using the four-way arrow, you can drag the chart anywhere on your worksheet, releasing the mouse button when it's in the right spot.
Click and drag with your mouse to move or resize the chart.Hover over the chart border until the mouse pointer changes to a four-way arrow.At the same time, three new tabs appear in the ribbon, under the Chart Tools heading. You'll notice that when you select a chart, Excel highlights the worksheet data the chart uses. You have to learn to grab hold of these floating boxes and place them where you really want them. The chart box doesn't damage your data in any way, but it can end up hiding your worksheet's numbers and text.
Depending on where Excel puts it, it may temporarily obscure your data. When you insert a chart into an existing worksheet, it becomes a floating object, hovering above your worksheet. If your chart is an embedded chart, you can freely move and resize it with you mouse.
0 kommentar(er)
