Move or resize a chart (2024)

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 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.

  1. Click anywhere in the chart.

    This displays the Chart Tools option on the ribbon

  2. Under Chart Tools, on the Design tab, in the Location group, click Move Chart.

    Move or resize a chart (1)

  3. Do one of the following:

  1. To resize a chart, do one of the following:

    • To change the size manually, click the chart, and then drag the sizing handles to the size that you want.

    • To use specific height and width measurements, on the Format tab, in the Size group, enter the size in the Height and Width box.
      Move or resize a chart (3)

    • To change the size and scaling of the chart, on the Format tab, in the Size group, click the Dialog Box Launcher

      Move or resize a chart (4)

      . Then in the Scale Height and Scale Width boxes, enter the numbers that you want.

      Move or resize a chart (5)

  1. Click anywhere in the chart.

    This displays the Chart Tools option on the ribbon.

  2. Click the Format tab, in the Size group, click the Dialog Box Launcher Move or resize a chart (6).

    Move or resize a chart (7)

  3. In the Format Chart Area pane, select Properties, and then select the appropriate option.

    Move or resize a chart (8)

Need more help?

You can always ask an expert in the Excel Tech Communityor get support inCommunities.

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Move or resize a chart (2024)

FAQs

Move or resize a 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.

How do you move and resize a chart? ›

Resize a Chart
  1. Click the chart to select it.
  2. Click and drag the chart's sizing handle. Make sure the two-headed arrow is activated before clicking and dragging.

How do I move a chart in Excel? ›

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.

How do I resize an Excel chart without losing formatting? ›

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.

How do I resize a chart in sheets? ›

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the chart you want to change.
  3. Drag the blue markers to resize the chart.

What is the difference between moving a chart and resizing a chart? ›

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.

How can you resize or move a table? ›

Resize an entire table manually
  1. Rest the cursor on the table until the table resize handle. appears at the lower-right corner of the table.
  2. Rest the cursor on the table resize handle until it becomes a double-headed arrow. .
  3. Drag the table boundary until the table is the size you want.

How do you resize an Excel worksheet? ›

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.

How do I resize a table in sheets? ›

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row or column to resize. To highlight multiple rows or columns: Mac: ⌘ + click the rows or columns. ...
  3. Right-click the row number or column letter.
  4. Click Resize row or Resize column. Then, choose an option: Enter a custom height or width. ...
  5. Click OK.

How do I resize a chart in slides? ›

Resizing and editing a chart

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.

How do I adjust the scale of a chart in Excel? ›

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.

How do I move a table in Excel? ›

Re: Drag-able Excel Tables

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.

Top Articles
Latest Posts
Article information

Author: Edmund Hettinger DC

Last Updated:

Views: 6267

Rating: 4.8 / 5 (78 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Edmund Hettinger DC

Birthday: 1994-08-17

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.