Hi,
A B
X Y
X Y
X Y
X Y
"" ""
"" ""
...
here is my question: the values in col A are "" or a date value and the values of col B are "" or a currency value. how would i make a chart to have a data range to not include any blanks?
for example above, the chart data range would be A1:B4
there cannot be "" within the range.
any help appreciated,
thanks,
helpplease!
Bookmarks