I have three sheets of data in my workbook. The sheet I am trying to graph is the monthly data. I want the graph to only show the most recent month with documented data. The data will come from the sum of cells in a different sheet. (You can see the formulas I have set up in the example).

The graph is functioning properly, except for that it is graphing the empty cells that have formulas in them as 0. I want to keep the formulas so the data auto-populates when I enter it, but I only want the most recent cells wtih actual data to graph.

Please seee the attached example. Thank you so much for your help!!!!!example.xls