Hi,

Try turning on Automatic recalculation - Tools, Options, Calculation,
Automatic. Or press F9 after you clear the data.

Question - if you are going to put new data in the data area why do you care
if the chart clears or not if when you add the new data the chart is updated?
Besides, why clear the data, why not just type over it with the new data?

--
Thanks,
Shane Devenshire


"CAPTGNVR" wrote:

Dear All

I have a 30 days info in one sheet and a chart based on this source.

When the month is over I delete the contents but the graph still shows in
the chart.

The way I am doing is to go to the chart-source and delete the source range
and re-enter same, then the chart gets cleared.

Can anyone tell me how to do in VB so that the source sheet contents are
deleted? (excel 97)

brgds/captgnvr