Chart cells in Row B only if corresponding cells in Row A are not empty

[kanonathena]

Hi all,

I have two rows of data, one is budget, one is actual. The Budget one has 12 values already filled out, the Actual one only has up to this month, about eight values. I want to plot both rows in the same chart, with Budget values going as far as the Actual value, so that budget value for future months are not plotted. Can this be done?


Thank you very much.

[Palmetto]

See Dynamic and Interactive Charting