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