Please help!!!! Need help with graph with sums from a different page!!

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

Hello
If you create a formula that returns the highest row that contains data greater than zero, you can use this in conjunction with the INDEX function to return the latest month greater than zero in the range. This can then be your chart data. See attached example.

Hope this helps.
DBY

Thank you so much!!!!!!!!!!!!! This worked perfect!!! I so appreciate it!

Your'e welcome. Thanks for the positive feedback.

DBY