To make a chart wider in Excel, select the chart and drag a middle sizing handle on its left or right edge; for a precise width, select the chart and enter a value in the Width box on the Format tab. Widening a chart gives long category labels, dates, and data series more room, but you may also need to reposition the legend or plot area to make the extra space useful. These steps are for Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook with a chart you can edit. If you do not have one yet, select your data and choose a chart from Insert.
- Enough room on the worksheet, or a plan to move the chart or adjust the print layout if it becomes wider than the visible area.
- For precise sizing, Excel desktop. Excel for the web supports basic chart resizing by dragging, but some sizing and formatting controls may be limited.
Step-by-Step
-
Select the chart itself. Click once near the chart’s outer border, away from a bar, line, data point, or label. When the whole chart is selected, a border with sizing handles appears. If only one series or chart element is selected, click an empty part of the chart area or press Esc and select the outer edge again. The distinction matters: changing the size of a selected chart element will not widen the complete chart.
-
Drag a side handle to widen it by eye. Point to the small handle at the middle of the chart’s left or right edge. When the pointer changes to a horizontal resize arrow, hold the mouse button and drag outward. Drag the right handle to keep the chart’s left edge in place; drag the left handle if you want the right edge to stay in place. Release the button when the chart has the width you want. Side handles change width without intentionally changing height, unlike a corner handle, which changes both dimensions.
-
Set an exact width when alignment matters. With the outer chart selected, open the contextual Format tab on the ribbon and find the Size group. Enter a new value in Width, then press Enter. If the Size group is not visible, widen the Excel window or open the ribbon’s overflow controls; the contextual Format tab only appears while a chart is selected. Use this method when matching several charts or fitting one to a report column. You can also set Height here if you need a specific overall shape.
-
Check how the chart sits on the worksheet. A wider chart may overlap cells or other objects, which does not change the underlying data but can make the sheet hard to use. Drag the chart by its outer border to reposition it, taking care not to grab a sizing handle. If you need to line up its edges with cells, use the worksheet grid as a visual guide and adjust the width in small increments. If the chart extends past the window, use the horizontal scroll bar to inspect its far edge.
-
Give the plot area room too. The chart area is the whole object, while the plot area is the inner region where bars, lines, or points appear. Excel sometimes reserves a large share of a newly widened chart for a legend, title, or labels. Click inside the plot area until its own border and handles appear, then drag a side handle to give the data region more width. Click the outer border again when you want to resize the complete chart. If selecting the inner region is difficult, click an open patch inside the gridlines rather than a data mark.
-
Review the legend and labels. A legend on the right can consume space that would otherwise go to the plot area. Select the chart, then use Chart Design > Add Chart Element > Legend to choose a different position, such as Bottom, or choose None if the series are clearly identified another way. Check the category-axis labels as well: widening may make them less crowded, but it will not fix labels that are too long or a legend that covers the data. Keep text readable rather than shrinking it until the chart becomes difficult to interpret.
-
Check the result in the way people will use it. Review the chart at normal worksheet zoom and, if it will be printed, open Print Preview to see whether the wider object fits the page. A chart can look spacious on screen but be scaled down when printed. If it is too wide for the page, reduce its width slightly, change the page orientation or print scaling as appropriate, or place it on a page by itself. Save the workbook after confirming that the chart is readable and not covering important worksheet content.
Common Mistakes
Dragging a data point instead of the chart border: this selects or edits a chart element rather than changing the whole object. Look for the handles around the outside edge before dragging. If the wrong element is active, press Esc and select the outer chart boundary again.
Using a corner handle when only width should change: a corner alters both width and height, which may make the chart unusually tall or short. Use a middle side handle for a horizontal-only change, or enter a value in the Width box for repeatable sizing.
Assuming more chart width always means more plot space: the legend, title, or data labels may still use a large amount of room. Adjust the relevant chart element or plot area instead of repeatedly enlarging the outer boundary.
Making the chart wider without checking the worksheet or printed page: it may overlap another chart, obscure cells, or be reduced to fit when printed. Inspect both the worksheet and Print Preview before considering the change finished.
Tips
Use an exact width when you want several charts to have a consistent size. Select each chart and enter the same value in the Format tab’s Width box; then compare their heights and align them by eye. Matching dimensions makes a dashboard easier to scan, but keep each chart large enough for its own labels and legend.
For a chart with many categories, use the added space to improve reading rather than simply filling the worksheet. A wider column chart can make category names less cramped; a wider line chart can spread dates across more horizontal space. If labels remain crowded, consider shortening source labels or showing fewer categories at once. Do not remove necessary context just to make the chart look tidy.
Make a small change, then review the chart before making another. This helps you tell whether the problem was the overall width, the plot area’s proportions, or a chart element taking up space. If the chart is part of a dashboard, leave consistent gaps between it and neighboring objects so it does not feel squeezed against other content.
On a Mac, selecting a chart and dragging its side handles works in much the same way. The ribbon may look different, and the contextual tab or sizing controls can be arranged differently from Windows; look for the chart’s Format controls and its Width field. In Excel for the web, try dragging the chart’s side handle. If you cannot enter an exact width or access a needed chart-formatting option, open the workbook in the desktop app.
Troubleshooting
The handles do not appear: click the chart’s outer edge once. If the worksheet is protected, editing objects may be restricted; check the Review tab for sheet protection and ask the workbook owner before changing protection settings. Also make sure you are not in cell-edit mode. Press Esc, then select the chart again.
The chart changes height as well as width: you probably dragged a corner handle. Undo immediately with Ctrl+Z on Windows, then use a middle handle on a side. Alternatively, restore the intended height using the Height box on the contextual Format tab and set Width separately.
The Width box is missing: confirm that the chart, not a cell or chart element, is selected. The contextual Format tab appears only when an appropriate object is active. If the ribbon is simplified or the Excel window is narrow, expand the ribbon or maximize the window and look in the Size group. If you are using Excel for the web, use the desktop version for controls that are unavailable there.
The plot still looks cramped after widening: select the plot area and adjust its boundary, then reconsider the legend position and long labels. If the chart is a stacked or clustered chart, preserve enough room to distinguish series and category labels. Widening cannot make an overcrowded data display clear if too many categories or series are shown at once.
The chart is cut off when printed: check Print Preview and the selected printer’s page settings. A wider chart may extend beyond the printable page area or prompt Excel to scale the sheet down. Try landscape orientation, a suitable print area, or a smaller chart width. Recheck the preview after each adjustment because print scaling can affect the whole worksheet, not just the chart.
Frequently Asked Questions
Can I enter an exact chart width in Excel?
Yes. Select the whole chart, open the contextual Format tab, and enter a value in the Width box in the Size group. The field’s displayed measurement units depend on Excel and your regional settings.
How do I make a chart wider without making it taller?
Drag the middle handle on the chart’s left or right edge. Avoid the corner handles, which change both dimensions. For an exact result, set Width in the Format tab and leave Height unchanged.
Why did widening my chart not make the bars or lines wider?
The extra area may have gone to the legend, title, or other chart elements, or the plot area may not have expanded as expected. Select the plot area and adjust it, or reposition the legend to give the data region more room.
Can I make multiple charts exactly the same width?
Yes. Select each chart in turn and enter the same number in the Width box. Compare their heights and placement too, since equal widths alone do not guarantee that the charts will align or look balanced.
Can I resize a chart in Excel for the web?
Basic resizing by dragging a chart handle is available in the web app. If you need a precise dimension or cannot find a particular formatting control, open the file in Excel for Microsoft 365 on Windows or Mac.
Will a wider chart change my data?
No. Resizing changes the chart object’s display, not the values in the worksheet or the chart’s source data. It can change how the chart is laid out, so review labels, legends, and the plot area afterward.
Related
- Average Growth Rate in Excel: Calculate It Step by Step
- How to Calculate an Average in an Excel Column
- Calculate Percentage in an Excel PivotTable
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table by Week: Group Dates or Add a Week FieldYes. In Excel for Microsoft 365 on Windows, put a real date field in a PivotTable’s Rows area,…
- Butterfly Chart in Excel: How to Build and Format OneTo make a butterfly chart in Excel, put the values for one group in a column as negative…
- Insert a Live Excel Chart Into PowerPoint and Update ItTo insert a live Excel chart into PowerPoint, copy the chart in Excel, then in PowerPoint for Microsoft…
- Power Pivot Not Working? Fix Common Excel ProblemsIf Power Pivot is not working in Excel for Microsoft 365 on Windows, first enable its COM add-in:…
- How to Add a Trendline to a Google Sheets ChartTo add a trendline in Google Sheets, click or double-click the chart, open Customize > Series in the…
- Half-Circle Charts in Excel: Create a Semi-DoughnutExcel does not have a dedicated half-circle chart button, but you can make one with a doughnut chart:…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.