How to Apply an Outline to a Chart Area in Excel

Charts & pivot tables · Updated November 20, 2026

To outline a chart in Excel for Microsoft 365 on Windows, right-click the chart’s outer background, choose Format Chart Area, open Fill & Line, and under Border select Solid line. Choose a color and width to make the outline visible. The chart area is the full chart object; if you want a border only around the data region, select and format the plot area instead.

An outline can separate a chart from nearby content, make it easier to spot on a busy worksheet, or give a report a consistent visual style. You can change its color, thickness, and line style, or remove it later without changing the chart data.

What You’ll Need

  • A workbook containing a chart. If you have not made one yet, select your data and use Insert to create a chart first.
  • Excel for Microsoft 365 on Windows for the steps below. Excel for Mac has similar chart formatting controls, while Excel for the web may offer fewer line options.
  • A clear idea of where the outline should appear: around the entire chart or around just the plot area containing the data.

Step-by-Step

  1. Select the chart. Click the chart once so Excel displays its selection handles and contextual chart tabs on the ribbon. If the chart is embedded on a worksheet, click inside its outer boundary, not a cell next to it. A chart selected as an object is ready for formatting; if you see data points or a single chart element selected instead, click the blank background near the chart’s edge.
  2. Open the chart-area formatting controls. Right-click a blank part of the chart background, preferably between the chart’s outer edge and the plot area, and choose Format Chart Area. Excel opens the Format Chart Area task pane. If the context menu instead offers Format Plot Area, Excel has identified the inner data region; click a different blank area near the chart’s outside edge and try again.
  3. Open Fill & Line. In the task pane, select the Fill & Line icon, usually shown as a paint bucket. Expand the Border section if it is collapsed. This section controls the line around the selected chart element. Do not confuse its controls with Fill, which changes the background color or transparency.
  4. Turn on the outline. Under Border, select Solid line. If No line is selected, the chart area has no visible border, even if the rest of the chart has a fill. Selecting a solid line adds an outline using the current default styling; you can then adjust the appearance using the settings below.
  5. Choose a line color. Open the Color menu and select a theme color, a standard color, or a custom color if that option is available. For a report, use a color that contrasts with the worksheet background but does not compete with the data. If you want a subtle frame, choose a medium or light neutral color rather than a bright accent.
  6. Set the line width and style. Adjust Width to make the border thinner or thicker. A narrow line is usually enough for a chart on a worksheet; a wider outline can work when the chart is being emphasized in a presentation. You can also choose a Dash type if you want a dashed or dotted border. Check the chart at its normal viewing size, since a line that looks restrained while zoomed in may be too heavy in the finished report.
  7. Review the outline in context. Click outside the task pane or select a worksheet cell to see the chart without the selection handles. Confirm that the border surrounds the full chart, including its title, legend, and labels, rather than just the plot area. If it is not the area you intended, repeat the selection process and format the other chart element.
  8. Close the pane and save. Close the Format Chart Area pane when you are satisfied. Save the workbook so the change is retained. The outline is part of the chart’s formatting, so it generally stays with the chart if you move or resize it on the worksheet.

Alternative ribbon route: Select the chart, then select the Format contextual tab under Chart Tools. In the Current Selection group, check that Chart Area is selected, then choose Format Selection to open its formatting pane. In some Excel builds, the contextual tab is labeled Chart Format. The right-click method is often simpler because Excel opens the pane for the element you clicked.

Common Mistakes

  • Formatting the plot area by mistake. The plot area is the inner rectangle where data appears. Its border does not enclose the title or legend. Use the outer chart background and look for Format Chart Area when you right-click.
  • Changing the fill instead of the border. Fill changes the background behind chart content; Border creates the outline. If the background changes but no edge appears, return to Fill & Line > Border and choose Solid line.
  • Leaving No line selected. A chosen color or width will not show while the border is set to No line. Select Solid line first, then review the color and width.
  • Choosing a color with too little contrast. A pale line on a white worksheet may technically be present but difficult to see. Test the chart at its expected display size and pick a line color with enough contrast.
  • Making the border too thick. A heavy outline can make the chart feel cramped or draw attention away from the values. Start with a modest width, then increase it only if the chart needs stronger separation.

Tips

  • Match the workbook theme. A theme color usually coordinates better with other workbook elements than an unrelated bright color. Use a neutral gray for a restrained frame or an accent color already used in the chart.
  • Keep chart area and plot area styling intentional. A chart-area outline frames the whole object; a plot-area outline frames the data field. You can format both, but two strong borders may look cluttered. If both are needed, make one less prominent.
  • Use a transparent chart fill when appropriate. The chart-area fill and border are separate settings. A transparent fill can let worksheet cells show through while preserving a visible outline. Check that labels and gridlines remain readable against whatever is behind the chart.
  • Reuse consistent styling. If several charts need the same appearance, format one carefully and use Excel’s chart-formatting options to apply a consistent style where available. Still check each chart’s title, legend, and background because a style that suits one chart may not suit another.
  • Consider the final destination. A thin outline can appear faint in a printed worksheet or exported image. Preview the page or export at the intended size, then adjust the width and contrast if the edge disappears.

Troubleshooting

The Format Chart Area command is missing. You may have right-clicked a data series, title, legend, or plot area. Click the chart’s outer background and try again. If selecting the correct blank space is difficult, select the chart and use the Current Selection list on the Format or Chart Format tab to choose Chart Area, then open Format Selection.

The outline does not appear after choosing a color. Confirm that Border is set to Solid line, not No line. Increase the width temporarily to make the change obvious, and choose a color that contrasts with the background. Also make sure the pane title says Format Chart Area; otherwise you may be editing a different element.

The border appears around only the data region. That is the plot-area border. Select the chart’s outside background and format Chart Area instead. The chart area includes the plot area plus items such as the title and legend. If the chart fills nearly all of its outer boundary, click a small blank space near a corner or use the Current Selection list to target the full chart area.

The controls or menus look different. Excel’s ribbon labels can vary slightly between Microsoft 365 updates, and Mac’s interface may arrange chart tools differently. On Mac, select the chart and use its contextual chart-formatting controls or control-click the chart background to open the formatting options; look for the chart-area line or border settings. In Excel for the web, some detailed line choices may be unavailable. If you cannot set the required width, dash style, or color, open the workbook in the desktop Excel app.

The outline vanishes when you click away. Selection handles can make a border seem more visible while a chart is selected. Click elsewhere and inspect the chart again. If the edge is still too faint, change its color or width. If the chart has been copied as a picture rather than as an editable chart, you may be formatting the picture outline instead; return to the original chart object if you need chart-area-specific controls.

Frequently Asked Questions

What is the difference between the chart area and plot area?
The chart area is the complete chart object, including its title, legend, and plot area. The plot area is the region where the data series and axes appear. Choose the chart area for a frame around the whole chart.

Can I add an outline without changing the chart background?
Yes. Set the border under Fill & Line > Border independently of the fill. You can leave the existing fill unchanged, or adjust its transparency separately if you want worksheet content to show behind the chart.

How do I remove an outline later?
Select or right-click the chart area, open its formatting pane, expand Border, and select No line. This removes the chart-area outline without deleting the chart or its data.

Can I use a dashed or dotted outline?
Yes. After selecting Solid line, choose a pattern from Dash type in the Border controls. The exact pattern choices can vary by Excel version. Use a pattern that remains clear at the chart’s normal size.

Does the outline print or appear in an exported chart?
Usually, yes: chart-area formatting is part of the chart and is included when the chart is printed or exported. Check Print Preview or the exported file, since a very thin or low-contrast line may be hard to see at the final size.

Can I outline a chart in Excel for the web?
You can select and format charts in Excel for the web, but some detailed border controls may differ or be unavailable. For the most complete control over line color, width, and dash style, open the workbook in Excel for Microsoft 365 desktop.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.