Do not chart zero values

[FSUMBA97]

I have a file where the values are updated each week and I am trying to chart (with a trend line) up-to-date values but not the zero or future values (tab attached). I have tried several methods including NA, blank, etc... Need some expert help. Thanks in advance. VCPU Chart Test.xlsx

[FDibbins]

1 quick way to do this is to hide the rows that have 0. I know its a manual process, but it works

[FSUMBA97]

Turning this over to a data entry team that is not good with Excel so it needs to be automatic as possible.

[FDibbins]

I cant think of any formula method, off the top of my head Maybe some1 will give you a VBA answer

[Andy Pope]

get the VLOOKUP to return #N/A instead of zero for future data points.

Use Named ranges to control size of data range used

[FSUMBA97]

Tried that, no luck. :-(

[Andy Pope]

tried what?

We can only test part of the problem as your example file is linked to an external source
='O:\Metrics\VCPU Files\[2013 EOD VCPU DECK.xlsx]WH Totals'!$D$4:$Q$374