I have a spread sheet that collects data all year.. A formula converts the operator input data weekly to a metric conversion. This formaula gives 0 if no data is entered and a range of 0-1000 once entered.
This is then moved to a graph that shows current demand compared to last years data. I need a way to not plot the 0 on the graph for the dates upcoming but still plot a 0 once data has been input.
thanks
