Make a Transparent Chart in Excel

Add to Favorites
Author: | Edits: don

How to make a Chart transparent so that it blends in with its background and surroundings in Excel.

  1. Hover your mouse over the chart and it will tell you if you are over the Chart Area or the Plot Area etc. Right-click the background of the chart when you are over the Chart Area and click Format Chart Area...
  2. A window will open.  In the Fill section, select No fill
  3. Go to the Border Color section and click No line
  4. Hit the Close button to go back to the chart.  It should now look like this:
  5. Hover your mouse over the remaining white part of the chart.  It should say Plot Area.  Right-click and click Format Plot Area...
  6. Another window will open.  Go to the Fill section and select No fill
  7. Hit Close at the bottom of the window and then click any cell in the worksheet to deselect the chart and see the final result. That's it!

Now we have a nice lovely chart that blends-in with the rest of the worksheet.


Make sure to download the spreadsheet that accompanies this tutorial so you can see the example in Excel.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Create Gantt Chart in Excel Easily
Tutorial: Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it sh...
Thermometer Chart in Excel
Tutorial: How to create a thermometer chart in Excel. This is what we want: Steps to Create a The...
Filter and Sort Data on Charts in Excel
Tutorial: Create a dynamic chart in Excel that displays only the data you want. You can filter it an...
How to Create and Manage a Chart in Excel
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Update, Change, and Manage the Data Used in a Chart in Excel
Tutorial: In this tutorial I am going to show you how to update, change and manage the data used by ...
Combine Multiple Chart Types in Excel to Make Powerful Charts
Tutorial: In this tutorial I am going to show you how to combine multiple chart types to create a si...