Excel charts – source data

Hi,

My Excel chart appears to picking up data when there is nothing actually in the source data for the chart.
I update the chart using a macro, which is identical to a macro that does a similar update but with different data. Cannot figure out why the chart still thinks there is data, even when I delete all data from those columns. Your answers are geatly appreciated.