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.
Notes:
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.)