Excel Chart for week 1 - 52

[starheartbeam]

I am trying to create an excel chart that will show me my inventory every week for each week of the year so that I can see the trend. I have a chart that I track the numbers daily and then on a different tab I have a chart that does a vlookup to get each Sunday's dates. I have the vlookup set to do all 52 weeks of this year even though not all of them return something right now as we have to had all the weeks.

=VLOOKUP(B3,Daily!A:C,3,FALSE)

Then when I graph my data it shows the data graphed for weeks 1-31 but drop it down to 0 for weeks 32-52. How can I get the graph to only show data that the VLOOKUP brings back data for?

 

[starheartbeam]

I figured it out. If anyone else needs to do something like this here is what I changed my VLOOKUP to be and now it only shows the ones with data.

=IF(VLOOKUP(B3,Daily!A:C,3,FALSE)>0,VLOOKUP(B3,Daily!A:C,3,FALSE),NA())

This put #NA when it does not return data and excel chart does not graph#NA