In this case it is showing the current worksheet (Good chart data example) but you can click the dropdown to see a list of the worksheets in the current spreadsheet. Excel will default to moving it as an object to another worksheet.You can now choose where you want to move your chart.
A pop-menu will appear with a number of options for changing the current chart.Ĭhoose Move Chart.
Another option is to right-click on an empty area of the chart, or along one of the edges.One way to do this is to simply copy and paste the chart to another worksheet.Move your Excel chart to another worksheet Note that if you float over the mid-point of one of the sides, the resize handle will be either horizontal or vertical rather than diagonal as shown here.This doesn't work if you drag one of the sides. If you are dragging one of the corners, you can hold the SHIFT key to resize the chart without changing the proportions of the chart.Click and drag the mouse to change the size of the chart.The cursor will change to a resize handle like this: Resize your Excel chart within the current worksheetįloat your mouse over one of the corners of the chart, or in the middle of one of the sides. The cursor will change to look as it does in this picture: Simply float your mouse over the outside edge of the chart, or inside the chart on an empty space.
Move your Excel chart to a different location within your worksheet Yes, that means that Excel will insert your chart on top of existing data if there is data in the center of your Excel window at the time you insert your chart. It will do this regardless of where you are in your worksheet, and what else might be there at the time. When you create a new chart, Excel will automatically insert the chart into the middle of your Excel screen. Moving and Resizing a chart can be necessary if you need to fit more than one chart onto your worksheet, or if Excel inserted the chart in the wrong place. It assumes that you've already created a chart, and that chart is sitting as an object on your worksheet. This lesson shows you various options for moving or resizing your chart so it looks how you want it to, where you want it to be. When creating a chart in Excel, Excel will default to inserting your new chart on the same worksheet that contains the data you created it from.
0 kommentar(er)
