How to Remove Chart Border in Excel

Removing the border from an Excel chart is a small change that can make a huge difference in your reports and dashboards. A borderless chart looks cleaner, more modern, and blends seamlessly into presentations, giving your work a polished, professional feel. This article will walk you through several easy methods for removing chart borders, from a quick right-click to setting up templates that do the work for you.

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 Should You Remove a Chart Border?

Before diving into the "how," let's quickly touch on the "why." Graphic design principles often emphasize simplicity and reducing "chart junk" - any visual element that isn't necessary to understand the data. A chart border is a prime example of this.

Here are a few reasons you might want to ditch the border:

• Cleaner Aesthetics: Removing the border instantly lifts the design, making it look less like a standard, boxy Excel output. It feels more intentional and thoughtfully designed.
• Better Integration: When you're building a dashboard or pasting a chart into a PowerPoint slide or Word document, a borderless chart integrates more naturally with the rest of your content. It doesn't scream, "I was just copied and pasted from a spreadsheet!"
• Reduced Visual Clutter: Your goal is to help your audience focus on the data, whether it's lines, bars, or pie slices. Removing unnecessary lines and boxes helps guide their eyes directly to what matters most.

Method 1: The Quickest Way Using the Format Pane

This is the most common and direct method for removing a chart border. Once you know where the option is, you’ll be able to do it in just a few seconds.

Step-by-Step Instructions:

• 1. Select Your Chart: Start by clicking anywhere on your chart to select it. You’ll know it’s selected when you see a border appear around the entire chart object with small circles (handles) at the corners and midpoints.
• 2. Open the Format Chart Area Pane: Move your cursor to the very edge of the chart (not on the title or the plot area itself). Right-click to open the context menu. Near the bottom of this menu, select Format Chart Area....
• 3. Find the Border Settings: A new pane will appear on the right side of your Excel window, titled "Format Chart Area." If it isn't already selected, click the paint bucket icon labeled "Fill & Line". Within this section, click on Border to expand its options.
• 4. Select "No line": Inside the Border menu, you’ll see several options like "Automatic," "Solid line," and "Gradient line." Simply select the No line radio button. The border around your chart will disappear immediately.

That's it! This is the most reliable method and gives you access to a full range of formatting options if you ever change your mind and want to customize the border instead of removing it.

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: Using the Format Tab on the Ribbon

If you prefer using the ribbon at the top of the Excel window, this method is for you. It accomplishes the same thing as the format pane but through a different set of clicks.

Step-by-Step Instructions:

• 1. Select the Chart: As before, click on your chart to select it.
• 2. Navigate to the Format Tab: When a chart is selected, two new contextual tabs will appear in the ribbon: Chart Design and Format. Click on the Format tab.
• 3. Choose "No Outline": In the "Shape Styles" group on the Format tab, find the Shape Outline dropdown menu. Click it to reveal a list of color options and other settings.
• 4. Select "No Outline" from the list. The chart border will vanish.

This method is handy because the "Shape Outline" command is consistent across different objects in Excel and PowerPoint. The same steps work for removing the border from a text box, a rectangle, or any other shape.

Troubleshooting: Removing the Inner Plot Area Border

Have you followed the steps above, but a pesky inner border remains? This usually means the line you're seeing isn't around the Chart Area, but the Plot Area - the inner box where your data is actually visualized.

Excel treats these as two separate elements.

How to Remove the Plot Area Border:

• 1. Select the Plot Area: Click inside your chart, specifically on the background where the gridlines or data points appear. Be careful not to click on a data series itself. You’ll know you’ve selected the plot area when a box appears just around the visualization area.
• 2. Format the Plot Area: Right-click on the selected plot area and choose Format Plot Area... from the context menu.
• 3. Select "No line": Just like with the Chart Area, a pane will open on the right. Under the "Fill & Line" (paint bucket) icon, expand the Border section and select No line.

This is an important distinction to remember. The Chart Area is the entire object, including the title and legend. The Plot Area is just the inner canvas of your graph.

Going a Step Further: For a Truly Minimalist Look

To create an even cleaner visual, you might want to remove other lines that can act as internal borders, such as gridlines and axis lines.

Remove Gridlines

Gridlines often add unnecessary clutter. To turn them off:

1. Select your chart. A plus sign (+) icon for "Chart Elements" will appear on the top right.
2. Click the plus sign to open the Chart Elements menu.
3. Uncheck the box next to Gridlines.

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

Remove Axis Lines

Sometimes the X or Y axis itself has a solid line that you might want to remove.

1. Click directly on the axis you want to change (e.g., the horizontal category axis at the bottom).
2. Right-click it and choose Format Axis....
3. In the pane on the right, go to the "Fill & Line" (paint bucket) icon and expand the Line section.
4. Select No line from the radio buttons.

Combining these techniques - no chart border, no plot area border, no gridlines, and no axis lines - gives you an ultra-clean, modern chart that truly directs focus to the data itself.

Automate It: Save a Borderless Chart as a Template

If you find yourself constantly removing chart borders, you can save yourself a lot of time by creating a chart template. This allows you to apply your custom formatting (including the lack of a border) with just a few clicks.

How to Create a Chart Template:

• 1. Perfect Your Chart: Start with a single chart. Remove the border, adjust the fonts, set your preferred colors, and make any other changes you want to be standard.
• 2. Save as Template: Once you're happy with the look, right-click on the chart area and select Save as Template....
• 3. Name Your Template: A dialog box will appear. Give your template a memorable name, like "Borderless Bar Chart," and click Save. Excel will automatically save it to the correct folder.

How to Use Your Chart Template:

Now, the next time you need to create a chart:

1. Select your data and go to the Insert tab.
2. In the Charts group, click the small icon in the bottom-right corner to open the "Insert Chart" dialog box.
3. Click on the All Charts tab.
4. At the top of the list on the left, you'll see a folder named Templates. Click it.
5. Select your custom template from the options that appear, and click OK.

Excel will instantly create a new chart with all of your saved formatting, border already removed.

Advanced Tip: Use a Quick VBA Macro to Remove All Borders

If you have a worksheet or workbook with dozens of existing charts that all need their borders removed, doing it manually would be a nightmare. In these situations, a simple VBA macro can do the job in seconds.

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

How to Use the Macro:

• 1. Open the VBA Editor: Press Alt + F11 (or Option + F11 on a Mac) to open the VBA editor.
• 2. Insert a New Module: In the editor's menu, go to Insert > Module. A blank code window will appear.
• 3. Paste the Code: Copy and paste the following code into the module window:

Sub RemoveAllChartBorders()
    Dim ws As Worksheet
    Dim chartObj As ChartObject

    ' Loop through each worksheet in the active workbook
    For Each ws In ActiveWorkbook.Worksheets
        ' Loop through each chart object on the worksheet
        For Each chartObj In ws.ChartObjects
            ' Set the chart area border to be invisible
            chartObj.Chart.ChartArea.Format.Line.Visible = msoFalse
            
            ' Optional: Also remove the plot area border
            chartObj.Chart.PlotArea.Format.Line.Visible = msoFalse
        Next chartObj
    Next ws

    ' Let the user know the process is complete
    MsgBox "All chart borders have been removed!"
End Sub

• 4. Run the Macro: Close the VBA editor to return to your spreadsheet. Press Alt + F8 to open the "Macro" dialog box. Select RemoveAllChartBorders from the list and click Run. The macro will cycle through every chart in your entire workbook and remove the borders. It's always a good idea to save a backup of your file before running any macro.

Final Thoughts

Polishing your Excel charts by removing their borders is a simple but effective technique for creating clearer, more professional reports. Whether you use the Format pane for a single chart, create templates for future use, or run a VBA macro for bulk changes, you can easily control every visual aspect of your data visualizations.

Ultimately, a good chart is one that communicates its insights with minimal friction. Spending hours manually exporting data and formatting, whether in Excel or another BI tool, slows you down. That’s why we built our platform to automate the entire process. With Graphed, we help you connect your data sources in seconds and use simple, natural language to get answers and build real-time dashboards - no manual chart formatting required.