How to Change Chart Height in Excel

Getting a chart in Excel to look just right can feel like a small but significant battle. Sometimes the default size squishes your data into an unreadable mess, while other times it sprawls across your worksheet, overshadowing everything else. This guide will walk you through several methods to change your chart's height, from simple dragging to precise, pixel-perfect adjustments.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Your Chart's Size Actually Matters

Before jumping into the "how," let's briefly touch on the "why." The dimensions of your chart aren't just about aesthetics, they directly impact how your data is perceived. A well-sized chart accomplishes three key things:

• Clarity: It ensures that labels, data points, and legends are all legible without causing eye strain. A chart that's too short can compress columns, making trends harder to spot.
• Professionalism: When you're building a dashboard or preparing a report for a presentation, consistency is crucial. Properly and uniformly sized charts give your work a polished, professional look.
• Impact: The right size helps the chart fit naturally within the context of your report or dashboard, communicating your message effectively without overwhelming or getting lost in the surrounding data.

Now, let's get into the step-by-step methods for getting that size just right.

Method 1: The Quick and Easy Click-and-Drag

This is the most intuitive and common way to resize a chart in Excel. If you just need a rough adjustment, this method will be your go-to.

Follow these simple steps:

1. Click anywhere on your chart to select it. You'll know it's selected when you see a border appear around it with small circles, or "handles," at the corners and midpoints.
2. Hover your cursor over one of the handles. Your cursor will change into a double-sided arrow.
3. To change the height, hover over the handle in the middle of the top or bottom border. Your cursor will become a vertical double-sided arrow.
4. Click and hold the mouse button, then drag the border up or down to your desired height. Release the mouse button when you're done.

This method also works for adjusting width by using the handles on the left and right borders, or for adjusting both at once using the corner handles.

Pro Tip: Maintaining Proportions while Dragging

Have you ever resized a chart and ended up with a stretched, distorted-looking visual? This happens when you change the height and width independently. To avoid this and keep your chart's original proportions, hold down the Shift key while you drag one of the corner handles. Excel will lock the chart's aspect ratio, ensuring it scales perfectly without skewing the visual elements.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 2: For Precision with the Format Tab

Sometimes, "close enough" isn't good enough. When you need your chart to be an exact height - perhaps to match other charts on a dashboard or fit perfectly into a specific slot in a report - the dragging method can be frustrating. For precise control, the Format tab is your best friend.

1. Select your chart by clicking on it.
2. Two new tabs will appear in the Ribbon at the top of Excel: "Chart Design" and "Format." Click on the Format tab.
3. On the far right of the Format ribbon, you'll find a "Size" group. This group has two boxes: "Shape Height" and "Shape Width."
4. Simply type your desired height directly into the "Shape Height" box and press Enter. You can use inches (e.g., 3") or centimeters (e.g., 7.5 cm), and Excel will adjust the chart instantly to those exact dimensions.

Using this method ensures all your charts can be made perfectly uniform, creating a clean and organized look for your reports.

Method 3: Advanced Control with the 'Format Chart Area' Pane

For even more control over size and properties, you can use the "Format Chart Area" pane. This side panel offers the same precision as the Format tab but includes a few extra useful options.

1. Right-click on an empty space within your chart's border (but not on a specific element like a bar or a line). A context menu will appear.
2. Select "Format Chart Area..." from the menu. A formatting pane will open on the right side of your screen.
3. In this pane, click on the "Size & Properties" icon (it looks like a square with arrows pointing out from it).
4. Under the "Size" section, you'll see input boxes for "Height" and "Width." Just like with the Format tab, you can enter precise values here.

Locking the Aspect Ratio

The Format Chart Area pane has a very handy feature: the "Lock aspect ratio" checkbox. If you check this box, Excel will automatically maintain the chart's proportions. Whenever you change the height, the width will adjust automatically (and vice versa) to prevent any distortion. This is a great "set it and forget it" alternative to holding down the Shift key every time you resize.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 4: Automate Resizing with VBA Macros

If you find yourself resizing dozens of charts regularly, doing it manually - even with the precision tools - can be a chore. This is where a little bit of Excel VBA (Visual Basic for Applications) can save you a massive amount of time. Even if you've never written code before, you can use the snippets below.

First, you need to open the VBA editor by pressing Alt + F11 on your keyboard. Then, go to Insert > Module to create a new module to place your code.

VBA Code to Resize a Single Named Chart

If you have one specific chart you always need to resize, you first need to find its name. Click the chart, and its name will appear in the Name Box (just to the left of the formula bar).

Then, you can use this simple macro. Copy and paste it into your module:

Sub ResizeSpecificChart()
    ' Define the worksheet the chart is on
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet's name

    ' Define the chart object using its name
    Dim chartObj As ChartObject
    Set chartObj = ws.ChartObjects("Chart 1") ' Change "Chart 1" to your chart's name

    ' Set the height in points (72 points = 1 inch)
    chartObj.Height = 216  ' (This sets the height to 3 inches)
End Sub

To run it, just click anywhere inside the code and press F5.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

VBA Code to Resize All Charts on a Worksheet

This is even more powerful. If you have a dashboard with 10 charts that all need to be the same height, this macro will do it in one click.

Sub ResizeAllChartsOnSheet()
    ' Define the worksheet
    Dim ws As Worksheet
    Set ws = ActiveSheet ' This will run on whichever sheet is currently active

    ' Loop through every chart on that sheet
    Dim chartObj As ChartObject
    For Each chartObj In ws.ChartObjects
        ' Set the desired height for each chart (in points)
        chartObj.Height = 250 ' Set to your desired height
    Next chartObj
End Sub

Run this macro by pressing F5, and instantly all charts on your active sheet will snap to the exact height you specified. It's a huge time-saver for anyone managing large reports or dashboards.

Bonus Tips for Perfect Chart Alignment

Adjusting the height is just one part of positioning your charts. Here are a couple of extra tricks:

• Snap to Grid: Hold down the Alt key while dragging or resizing your chart. This will cause the chart's borders to "snap" to the worksheet's cell gridlines, making it incredibly easy to align multiple charts perfectly.
• Consider Font Size: As you make a chart smaller, the text for its title, axes, and labels can become unreadable. And when you make it larger, the font might look comically small. After resizing, you may need to manually adjust the font sizes to make sure they're appropriate for the new dimensions.

Final Thoughts

Mastering how to resize charts gives you foundational control over the story your data tells. Whether you're using a quick click-and-drag for a fast adjustment, the Format tab for perfect uniformity, or a VBA macro to automate your workflow, you now have the tools needed to make your visuals clear, professional, and impactful.

While perfecting these skills in Excel is valuable, we know that manually building, adjusting, and refreshing reports is what consumes the most time. For teams who are tired of wrangling spreadsheet data and want to get straight to the insights, tools like Graphed offer a faster way. We built it so you can connect data sources like Shopify or Google Analytics and create entire real-time dashboards just by describing what you want to see in plain English, skipping the manual formatting and data-pulling process entirely.