Hi Tushar,

just
hide that row (and, of course, set the appropriate option to only plot
visible cells).

Good one!

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk