How to Hide Chart Data in Excel – 6 Steps

The sample dataset contains information on sales amounts in three months. To hide the sales amount for February:

Step-by-Step Procedures to Hide Chart Data in Excel

 

STEP 1 – Plotting a Chart in Excel

  • Select any cell in the dataset and press Ctrl + A to select all used cells.

Step-by-Step Procedures to Hide Chart Data in Excel

  • Go to the Insert tab and select Insert Line.
  • Select Line.

Step-by-Step Procedures to Hide Chart Data in Excel

  • You will see a line chart.

Step-by-Step Procedures to Hide Chart Data in Excel

Read More: How to Edit Chart Data in Excel


STEP 2 – Inserting a Chart Data Table

  • Select the chart. A plus (+) icon will appear on the top right side of the chart.
  • Click the plus (+) icon.
  • Check Data Table.

Step-by-Step Procedures to Hide Chart Data in Excel

  • You can see the dataset inside the chart.

Step-by-Step Procedures to Hide Chart Data in Excel

Read More: How to Change Data Source in Excel Chart


STEP 3 – Hiding Chart Data in Excel

  • Select D4:D9.

Step-by-Step Procedures to Hide Chart Data in Excel

  • Press Ctrl + 1 to open the Format Cells dialog box.
  • Click the Number tab and select Custom.
  • Enter three semicolons (;;;) in Type.
  • Click OK.

Step-by-Step Procedures to Hide Chart Data in Excel

  • You will hide the data for February in the dataset.

Step-by-Step Procedures to Hide Chart Data in Excel

  • And also in the Data Table.

Step-by-Step Procedures to Hide Chart Data in Excel


STEP 4 – Removing Legend Keys to Hide Chart Data

  • To remove Legend Keys, select the chart and click the plus (+) icon.
  • Select the arrow to see the options.
  • Select No Legend Keys.

Step-by-Step Procedures to Hide Chart Data in Excel

  • No Legend Keys for February will be displayed.

Step-by-Step Procedures to Hide Chart Data in Excel

Read More: How to Remove One Data Point from Excel Chart


STEP 5 – Remove the Chart Data Table Borders

  • Select the chart and click the plus (+) icon.
  • Select the arrow to see the options.
  • Select More Options to open Format Data Table.

Step-by-Step Procedures to Hide Chart Data in Excel

  • Uncheck Table Borders in Data Table Options.

Step-by-Step Procedures to Hide Chart Data in Excel

  • This is the output.

Step-by-Step Procedures to Hide Chart Data in Excel


STEP 6  – Deleting Chart Legends

  • Click the Legends and press Delete.

Step-by-Step Procedures to Hide Chart Data in Excel

  • This is the output.

Step-by-Step Procedures to Hide Chart Data in Excel


How to Hide Empty Data in an Excel Chart

There is empty data in C7.

How to Hide Empty Data in Excel Chart

STEPS:

  • Select the column with the empty cell.
  • Rightclick the column index.
  • Select Hide.

How to Hide Empty Data in Excel Chart

  • Select all cells in the dataset.

How to Hide Empty Data in Excel Chart

  • Go to the Insert tab and select Insert Column.
  • Choose Clustered Column.

  • You will see the chart. Data for January is hidden.

  • Select the chart and go to the Chart Design tab.
  • Click Select Data to open the Select Data Source dialog box.

  • Click Hidden and Empty Cells.

  • Check Show data in hidden rows and columns in Hidden and Empty Cell Settings.
  • Click OK.

  • You will see the data for January.

  • In a line chart, this is the output. There is a disconnected line for January because of the empty cell.

  • Select ‘Connect data points with line’ in Hidden and Empty Cell Settings.

  • This is the output.


Download Practice Workbook

Download the practice book.


 

Related Articles


<< Go Back to Data for Excel ChartsExcel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo