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
Bookmarks