SOLVED

Unable to hide blank values in chart

Copper Contributor

I built a chart in Excel that points to various data points. I can't seem to get the chart to change, however, when I change the options for handling blank values. Here's how I have it currently (to connect to the line):

bungee41_0-1693493233612.png

 

When I change it to Gaps, no change:

bungee41_1-1693493298008.png

 

I'm not finding anything online except to change these values, but what if they aren't affecting anything?

 

I'll say that my data comes from a VLOOKUP function to pull from another sheet. The blank values are an empty string like "" for when the source cell is empty. Otherwise, it was giving me a 0 value, which I don't want. Is there a better/different way to handle that?

2 Replies
best response confirmed by bungee41 (Copper Contributor)
Solution

@bungee41 

"" is not an empty cell.

Amend you formula:

=IFERROR(1/(1/VLOOKUP()),NA())

Then the "Show #NA as an empty cell" should work.

 

Untested.

 

That did the trick. Thanks!
1 best response

Accepted Solutions
best response confirmed by bungee41 (Copper Contributor)
Solution

@bungee41 

"" is not an empty cell.

Amend you formula:

=IFERROR(1/(1/VLOOKUP()),NA())

Then the "Show #NA as an empty cell" should work.

 

Untested.

 

View solution in original post