Forum Discussion

bungee41's avatar
bungee41
Copper Contributor
Aug 31, 2023
Solved

Unable to hide blank values in chart

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

 

When I change it to Gaps, no change:

 

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?

Charting
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Aug 31, 2023

    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.

     

Resources