Forum Discussion
#N/A showing in chart
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 ...
It's a bit of a "cheat" but you can
add another set of data
turn it to a line chart
add data label
set the line colour to "no line"
I've attached a file