Move or resize a chart in Excel for Mac (2024)

FAQs

Move or resize a chart in Excel for Mac? ›

Click anywhere in the chart. CONTROL+click or right-click, and then click Format Chart Area. tab. Select Move and size with cells.

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. . Then in the Scale Height and Scale Width boxes, enter the numbers that you want.

In the worksheet, click File > Print. Under Settings, click Custom Scaling > Custom Scaling Options. Click Page and in the Adjust to box, choose a percentage by which you want to increase or decrease the font size.

Move or copy just the contents of a cell

Select the row or column that you want to move or copy. In the cell, click where you want to paste the characters, or double-click another cell to move or copy the data.

Changing the Scale of a Graph

Double-click on the y-axis and a Format Axis box will appear as shown below: Click on the scale button. Try changing the y-axis scale to range from 13 to 25. Click OK, and your modified graph will appear.

Under Chart Tools, on the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series that you want to change the order of. Click the Move Up or Move Down arrows to move the data series to the position that you want.

Move a chart to another sheet

Click anywhere in the chart. On the Chart Design tab, click Move Chart. Select the New sheet option, and then in the New sheet box, type a name for the new chart sheet. Select the Object in option, and then in the Object in box, select the sheet that you want to place the chart on.

How do you align charts in Excel on a Mac? ›

Was this reply helpful? I hope the following works on Mac: Click on the chart to select it. In the Format tab of the ribbon (to the right of the Chart Design tab), in the Arrange group, click Align > Snap to Grid.

Choose File > Reduce File Size (from the File menu at the top of the screen). Select the adjustments you want to make: Scale down large images: Images are scaled to the resolution used in the spreadsheet while preserving visual quality.

Click and drag across the column headings for the columns that you want to change. Note: If you have to change the width of only one column, you don't have to select it first. Point to the separator on the right side of any selected column heading.

Another option is to drag the ▟ at the lower right corner of the table - right to add columns, down to add rows.