I have created a dynamic chart, courtesy of the Jon Peltier website. No problem with getting the chart to work, the problem comes when I delete the data. I get an error message telling me that 'A formula in the worksheet contains one or more invalid references.' Any ideas as to how I can overcome this? Any suggestions welcome, apart from 'Don't delete the data then'