#N/A showing in graph

Hello,

In the attached spreadsheet, in columns D through G, I have formulas that are used to update the graph below. I’m running in to an issue with the #N/A’s showing on the graph, and not the actual value of the cell (the #N/A is set-up to show in the formula if the percentage in column B does not meet the criteria summarized in row 1). For example, in the chart, the “Metra” value is displaying #N/A, but if you hover over the blue bar, you see the value of 1.0%. Does anyone know how to have the actual value of 1.0% show, and not the #N/A? I’m also running into the same issue with the “Pace ADA” bar.

Thanks for your help.

I've fixed what you have in the attached but this was only done by adding the labels for each series to the end of each bar type and removing the #N/As manually. Not sure if you can automise this.

Hi Kersplash,

Thanks for looking. I'm having the same problem trying to automate, it doesn't seem like it can happen with this graph. Thanks again.

Tim