Hi,
I have a spreadsheet that I input data into daily. I then use an if and vlookup on the date to pull through any data earlier than todays date and this is charted. Unfortunately though my chart shows all the sata, including the dates with nothing in, so the line drops down to nothing and doesn't look good.
Is there a formula I can put into the data source box so that it only displays the data from today and earlier?
Graph.jpg
Bookmarks