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!