Question Locked

Excel charts - source data

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by thumbsup2

If you copied the macro from one spreadsheet to the next, make sure the macro is calling the new spreadsheet and not pulling data from the old one.

This discussion is closed to new replies.