Excel for Microsoft 365Excel 2021Excel 2019Excel 2016Excel 2013 More...Less
You can move a chart to any location on a worksheet or to a new or existing worksheet. You can also change the size of the chart for a better fit.
By default, a chart is moved and sized with cells. When you change the size of cells on the worksheet, the size of the chart adjusts accordingly. You can change this positioning option if you don't want to move or resize the chart together with the worksheet cells.
To move a chart, drag it to the location that you want.
Click anywhere in the chart.
This displays the Chart Tools option on the ribbon
Under Chart Tools, on the Design tab, in the Location group, click Move Chart.
Do one of the following:
To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet.
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.
Click anywhere in the chart. Under Chart Tools, on the Design tab, in the Location group, click Move Chart. Do one of the following: To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet.
Click anywhere in the chart. Under Chart Tools, on the Design tab, in the Location group, click Move Chart. Do one of the following: To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet.
Click the chart, and then on the Format tab, in the Size group, enter the size in the Shape Height and Shape Width boxes. Tip: To maintain the proportions as you resize a chart, select the Lock Aspect Ratio check box between Shape Height and Shape Width.
You can move a chart to any location on a worksheet or to a new or existing worksheet. You can also change the size of the chart for a better fit. By default, a chart is moved and sized with cells.When you change the size of cells on the worksheet, the size of the chart adjusts accordingly.
To do that, in Page Setup, click the window launcher button.Then, click Scaling > Adjust to, and then enter the percentage of the normal size that you want to use.
You can resize it by clicking and dragging the sizing handles. Use one of the handles in the corner to prevent the chart from stretching out of proportion. You can also click and drag the chart to reposition it.
Click the chart. On the Format tab, click Vertical (Value) Axis in the dropdown list and then click Format Pane. In the Format Axis pane, click Axis Options, and then do one or more of the following: Important The following scaling options are available only when a value axis is selected.
If an entire table is selected, it may be dragged and dropped to its new location on the worksheet. To move a table to another worksheet Ctrl/X will cut the sheet and Ctrl/V will place it within its new sheet.
Address: 2033 Gerhold Pine, Port Jocelyn, VA 12101-5654
Phone: +8524399971620
Job: Central Manufacturing Supervisor
Hobby: Jogging, Metalworking, Tai chi, Shopping, Puzzles, Rock climbing, Crocheting
Introduction: My name is Edmund Hettinger DC, I am a adventurous, colorful, gifted, determined, precious, open, colorful person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.