I use Excel 2010. I have a graph that pulls data for upcoming dates. If the date is in the future, there is not data and the formula naturally returns a Div error. I saw recommendations to replace this error with "" or with "N/A" so the graph would not graph these plots but my graph still does no matter what I try.
can someone help with the replacement formula or chart settings to not graph zero percentages?
See image.graph.jpg
Bookmarks