Internal Comparison Template Example.xlsxHello Everyone! SO I've created a Bar graph with multiple data sets. I used True False validation combined with IF And Statements to turn on or off the data sets. When it is turned off the value is #N/A, the Bar for that data set is gone, which is great. My Problem is the Labels stay on the graph and are displayed as #N/A. Is there a way to hide the labels when the returning value is #N/A and display them when they return a the actual value?
Bookmarks