Dynamic Graph/ Graph Data updates

I use an INDEX and MATCH for a table to match raw data into a graphing chart that I use a macro to update every month. I want my graph to graph up and till the latest month of data that I have. I want it to cut the graph off at March, before the #N/A's start. How do I do this?

Dec-14 1000
Jan-15 800
Feb-15 1200
Mar-15 1700
Apr-15 #N/A
May-15 #N/A
Jun-15 #N/A
Jul-15 #N/A

Hello
If your sample data was for example in the range A2:B9, then you could create two dynamic named ranges and apply these to your chart, for the dates:

Please Login or Register  to view this content.

And for the numerical values:

Please Login or Register  to view this content.

As you overwrite the #N/A's with number values the chart will expand accordingly. Depending on the amount of potential data you would have to expand the COUNT function range.

Hope this helps.
DBY