Thank you Shane for quick response.

It is on automatic calculation. Hvr, wl try pressing F(.

I did not try the chart after putting the new data. I just saw after
erasing the data the chart was still showing and so wanted to find out.

I have to clear the data after the month is over and enter daily information
and see the chart-- (it is like oil tanks temperatures)

Thnks n brgds/captgnvr

"ShaneDevenshire" wrote:

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