Skip to content

Latest commit

 

History

History
36 lines (22 loc) · 813 Bytes

Excel.Chart.DisplayBlanksAs.md

File metadata and controls

36 lines (22 loc) · 813 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Chart.DisplayBlanksAs property (Excel)
vbaxl10.chm149101
vbaxl10.chm149101
Excel.Chart.DisplayBlanksAs
b4e18939-6214-25e8-a0cd-c984b9f82346
04/16/2019
medium

Chart.DisplayBlanksAs property (Excel)

Returns or sets the way that blank cells are plotted on a chart. Can be one of the XlDisplayBlanksAs constants. Read/write Long.

Syntax

expression.DisplayBlanksAs

expression A variable that represents a Chart object.

Example

This example sets Microsoft Excel to not plot blank cells on Chart1.

Charts("Chart1").DisplayBlanksAs = xlNotPlotted

[!includeSupport and feedback]