Chart update using button
 

Hi

How do i update chart using Command Button and VBA

I have D10:D500 where i need to plot chart on those values I have ""
this on D10:D500 if there is no data on other column E10:E500 , problem
is its assuming that its 0 If there is no value on the D column cell
and my chart comes back to Zero and a stright line.

Is there any way to update chart using command button if only there is
Value on D10:D500 ?

I have 4 sheets sheet1!D10:D500 , Sheet2D10:D500 all are plotted on the
same chart comparing the performance of each work sheet on Chart

hope this can be done

thank you in advance...

Regards
Jay