Excel for historicsweetsballroom.com 365 Word for historicsweetsballroom.com 365 Outlook because that historicsweetsballroom.com 365 PowerPoint because that historicsweetsballroom.com 365 Excel 2021 native 2021 Outlook 2021 PowerPoint 2021 Excel 2019 indigenous 2019 Outlook 2019 PowerPoint 2019 Excel 2016 word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 indigenous 2013 Outlook 2013 PowerPoint 2013 Excel 2010 native 2010 Outlook 2010 PowerPoint 2010 Excel 2007 native 2007 Outlook 2007 PowerPoint 2007 More...Less

By default, data that is covert in rows and also columns in the worksheet is not displayed in a chart, and also empty cells or null worths are shown as gaps. For most chart types, you can screen the covert data in a chart.

You are watching: Which are not displayed on a graph

For line, scatter, and radar graph types, you can also adjust the way that empty cells, and also cells that display screen the #N/A error are shown in the chart. Instead of displaying empty cells together gaps, you can screen empty cells as zero worths (0), or you can expectancy the gaps with a line. For #N/A values, friend can pick to display screen those as an empty cabinet or attach data points with a line. The adhering to examples show Excel’s behavior with each of this options.

Options for mirroring empty cells






Change the means that north cells, null (#N/A) values, and hidden rows and columns are presented in a chart

Click the graph you want to change.

Go to Chart Tools on the Ribbon, then on the Design tab, in the Data group, click Select Data.


Click Hidden and Empty Cells.


In the Show north cells as: alternatives box, click Gaps, Zero, or Connect data points with line.

Note: On a scatter chart that display screens only markers (without connecting lines), friend can screen empty cells together gaps or zero only — you cannot affix the data points with a line.


In order to maintain backwards compatibility with various other versions the Excel, this attribute is off by default.

Click the Show data in hidden rows and also columns alternative if you desire Excel to plot surprise data.

See more: Which Of The Following Is Not A Sedimentary Rock, Multiple Choice Questions Sedimentary Rocks

peak of web page

Need more help?

You can constantly ask an professional in the Excel technology Community, acquire historicsweetsballroom.com in the answer community, or indicate a new feature or improvement. see just how do I offer feedback ~ above historicsweetsballroom.com Office? come learn how to share your thoughts. We"re listening.

Related Topics

produce a chart from start to end up

Thank you! Any much more feedback? (The much more you tell us the an ext we deserve to help.)Can you help us improve? (The much more you tell united state the more we have the right to help.)