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.
Bookmarks