B
Bob
Hello,
Using Excel 2007.
Have a column that I pre-formated with consecutive dates running downwards.
Occasionally, next to some date, there is some data.
I chart this data.
On the data page, I would like to coalese and remove the rows that have
a date, but No data for them (leaving the chart, and future chart
updating) unchanged.
How can I remove these "non-data" lines please, without messing anything
else up ?
Thanks,
Bob
Using Excel 2007.
Have a column that I pre-formated with consecutive dates running downwards.
Occasionally, next to some date, there is some data.
I chart this data.
On the data page, I would like to coalese and remove the rows that have
a date, but No data for them (leaving the chart, and future chart
updating) unchanged.
How can I remove these "non-data" lines please, without messing anything
else up ?
Thanks,
Bob