About this lesson
Many users fear #N/A values appearing in their spreadsheets. This module explores how to create this result with the NA() function, and why it's fantastic for charts
Benefits of NA Values
Why #N/A values can actually be a good thing in Excel.
When to use
Use #N/A values to suppress data points from being plotted on your charts.
The benefits of #N/A values
- Data points with a value of #N/A are not plotted on the chart
- When an axis label is also set to an #N/A value, it will not show on the axis either
#N/A vs 0
- A 0 will plot as a valid data point on the 0 axis
- #N/A will not plot on the chart at all
Triggering #N/A values
- An #N/A value can be triggered by using the =NA() function
Hints & tips
- Remember that the NA() function can also be used as a valid True or False result in an IF() function
- In order to completely suppress a value from both the plot area and axis, the field that drives the axis must also show as #N/A
Lesson notes are only available for subscribers.