How to Change Chart Size in Excel

Perfecting the size of your chart feels like a minor detail, but it can make all the difference between a cluttered, confusing spreadsheet and a clean, professional report. If you've ever wrestled with a chart that's just a little too big or small, you're in the right place. This article will walk you through several easy methods for resizing charts in Excel, from simple dragging to pixel-perfect adjustments, ensuring your data visualizations look exactly how you want them to.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding the Basics: Chart Area vs. Plot Area

Before we jump into resizing, it's helpful to understand the two main parts of any Excel chart you might want to adjust. Think of your chart as a picture in a frame.

• Chart Area: This is the entire object - the picture and the frame together. It includes the chart itself, titles, legends, axis labels, and all the surrounding whitespace. When you click on the outer edge of a chart, you've selected the Chart Area. Resizing this makes everything bigger or smaller.
• Plot Area: This is just the "picture" part - the actual visual representation of your data, like the bars in a bar chart, the line in a line chart, and the gridlines behind them. You can resize the Plot Area inside the Chart Area to give your data more (or less) space to breathe without changing the overall size of the chart object on your worksheet.

For most of this guide, we'll focus on resizing the entire Chart Area, which is what people usually mean when they want to change a chart's size. But we’ll touch on tweaking the Plot Area, too.

Method 1: The Quick Drag-and-Drop

The fastest and most common way to resize a chart is by using your mouse. It’s intuitive and perfect for quick adjustments when you just need the chart to roughly fit within a certain space.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions:

1. Select your chart: Simply click anywhere on your chart. You'll see a border appear around the entire Chart Area, with several small circles or squares on the corners and sides. These are called sizing handles.
2. Hover over a sizing handle: Move your mouse cursor over one of the handles. Your cursor will change into a two-sided arrow.
3. Click and drag to resize:
4. Release the mouse button: Once the chart is the size you want, let go of the mouse button. The chart will lock into its new dimensions.

This method is great for eye-balling the size and getting a general fit. It’s what most people use day-to-day for tidying up a worksheet.

Method 2: Precise Sizing with the Format Tab

Sometimes, "close enough" isn't good enough. When you need your charts to be an exact size - for example, making all charts in a report identical for a clean dashboard look - manually dragging with a mouse is too clumsy. Excel’s Format tab gives you complete control down to the inch or centimeter.

Step-by-Step Instructions:

1. Select your chart: Click on your chart to make it active. This will cause new contextual tabs to appear at the end of the Excel ribbon at the top of the screen. Look for the "Chart Design" and "Format" tabs.
2. Navigate to the Format tab: Click on the "Format" tab in the ribbon.
3. Find the size group: On the far right of the "Format" ribbon, you'll find a group called "Size." There are two boxes here: "Shape Height" and "Shape Width."
4. Enter your exact dimensions: You can type your desired height and width directly into these boxes. You can use inches ("in") or centimeters ("cm"), depending on your regional settings. For example, typing 3 into Height and 5 into Width will resize your chart to exactly 3 inches high by 5 inches wide.

Pro Tip: Locking the Aspect Ratio

What if you want to resize the chart to an exact height but have the width adjust automatically to keep the proportions correct? You can lock the aspect ratio.

• In that same "Size" group on the "Format" tab, click the tiny icon in the bottom-right corner (this is called the Dialog Box Launcher).
• A "Format Chart Area" pane will open on the right side of your screen.
• Under the "Size" section, make sure the box next to Lock aspect ratio is checked.
• Now, when you go back to the Height and Width boxes in the ribbon and change one value, the other will automatically update to maintain the chart's original proportions.

This method is fantastic for creating uniform and professional reports where consistency across multiple elements is crucial.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 3: Snapping-to-Cells for Perfect Alignment

You might have created the perfectly-sized chart but then spent too much time trying to get it lined up perfectly with the rows and columns in your sheet. There's a great trick to solve this problem as well.

By holding the Alt key on your keyboard while resizing or moving your chart, you can make it snap to the nearest grid lines. This makes it incredibly easy to create a neat dashboard, as the chart will align precisely with the defined sections.

Step-by-Step Instructions:

1. Select your chart: Click on the chart to select it.
2. Press and hold the Alt key: With your chart selected, press and hold the Alt key.
3. Click on one of the sizing handles: Click on one of the sizing handles (corners or sides) and start to drag while keeping the Alt key held down. You'll notice that as you drag, the border snaps to the nearest column or row line rather than moving smoothly.
4. Move both chart and resize: You can also move the chart by clicking its center and holding Alt while dragging. This will lock your chart's corners to cell corners. Then you can resize by holding Alt and dragging the corners, making the borders snap perfectly aligned.

This technique is a game-changer. It takes the guesswork out of effectively positioning your chart, giving your reports a crisp and professional appearance.

Method 4: Resizing the Chart Area vs. the Plot Area

As mentioned earlier, you can also resize the plot area independently from the overall chart area. This is useful when the chart object itself is the right size, but the actual graph feels cramped or too spaced out.

When to Adjust the Plot Area:

• Your chart's data bars or points look too small, with excessive white space around them inside the chart area.
• Your legend, titles, or axis labels are taking up too much room, squeezing the actual visualization.
• You want to manually accommodate long data labels without changing the entire chart's footprint.

Step-by-Step Instructions:

1. Select the chart area first: Click on the outer border of your chart.
2. Then, select the plot area: Click once inside the chart, directly on the gridlines or where the bars/lines are located. You will see a new border with sizing handles appear only around the plot itself.
3. Click and drag a handle: Drag the handles of the plot area to expand or shrink it within the confines of the larger chart area. The titles and legend will remain stationary while you make more room for your data to shine.

This is a more nuanced adjustment that gives you an extra layer of control over the composition and final presentation of your visual.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 5: Resizing Multiple Charts Simultaneously

If you're creating a dashboard with four, five, or more charts, ensuring they are all the exact same size by hand is tedious and prone to error. Fortunately, Excel lets you group and resize them all in one go.

Step-by-Step Instructions:

1. Select your first chart: Click on the first chart you want to include in the group.
2. Select additional charts: Hold down the Ctrl key (on Windows) or Cmd key (on Mac) on your keyboard. While holding the key, click on each of the other charts you want to resize. You'll see each one become selected.
3. Use the Format tab for resizing: With all charts selected, go to the Format tab on the ribbon.
4. Enter the dimensions: Use the Shape Height and Shape Width boxes in the "Size" group, just as you would for a single chart. When you enter a value and press Enter, all selected charts will instantly snap to those precise dimensions.

This trick is a massive time-saver for anyone building dashboards in Excel. You can follow this up with the Alt key movement trick to align your newly uniform charts perfectly on the grid.

Final Thoughts

From a quick drag-and-drop to setting exact dimensions and snapping to the grid, Excel provides all the tools you need to resize your charts effectively. Mastering these methods will elevate your reports from looking messy and functional to polished, professional, and easy to read.

Ultimately, the goal is to get this kind of reporting work done faster so you can focus on the insights. Instead of manually adjusting individual elements in a spreadsheet, we built Graphed to do the heavy lifting for you. You can connect your data sources - like Google Analytics, HubSpot, or Shopify - and simply ask in plain English to build a dashboard. Graphed creates clean, professional, and auto-updating visualizations in seconds, so you get to skip the manual setup and jump straight to making data-driven decisions.