How to Remove Chart Border in Excel (with Quick Steps)

Whether you are wondering how to remove a chart border in Excel, you have come to the perfect spot. We regularly need to build charts in Excel for the purposes of various jobs or projects. To properly display or portray the chart, we must eliminate the borders. In this post, we will look at how to remove a chart border in Excel.


How to Remove Chart Border in Excel: Quick Steps

Assuming that we have the following data of the accompanying figure, we are going to discuss an Excel process to remove the chart border. In this data, we have Year, Worldwide Inflation (%), and Average Closing Price of Oil ($) columns.

the data of the accompanying figure: How to Remove Chart Border in Excel

After proper procedures, we created an Excel chart with this data like the following image.

Relation Between Inflation and Oil Price

We have added border around the chart and for some reason, we need to remove the border part from the chart. Let’s see the workaround.


⦿ Step 1: Click on Chart and Select ‘Format Chart Area…’ Option

  • Firstly, in order to remove the chart border, we will choose the chart of the Relationship Between Inflation and Oil Price >> right-click on the mouse, and then select Format Chart Area.

Right-click on the mouse, and then select Format Chart Area…


⦿ Step 2: Select ‘No Line’ Radio Button from Format Chart Area Pane

  • Now in the Chart Options, go to Border >> No Line.

Remove Chart Border in Excel

  • Notice that the thin border line is no longer there.

The thin border line is no longer there


How to Change Chart Border in Excel

Now if changing borders may sometimes be a better option than No Border. In that case-

  • Go to the Chart Option, and then go to Border >> Solid Line. Excel users may opt to change Border Color, Width, Cap Type, Join Type, and so on.

In Chart Option, and then go to Border and go to Solid Line

  • After modifying according to the previous image, the chart will look like the following image.

After modifying, the chart will look like the image

Read More: How to Add Vertical Line in Excel Graph


Download Practice Workbook

You can download the practice workbook from the following download button.


Conclusion

Follow these steps and stages on how to remove a chart border in Excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section.


Related Articles


<< Go Back to Formatting Chart in Excel | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo