Hi folks,
I'm setting up an dynamic excel sheet here where I would like it to only update when column G is populated. The problem is that column G contains a formula which is blank until other info is entered. However, when I go to define ranges it seems to see the range as the whole year and not just the data that is displayed.
Is there a way I can create a graph that only updates when column G is populated with a number?
Cheers,
Manolis
Bookmarks