Creating a range out of a scattered cells with MFC Excel automation

[dushkin]

Hello all.

I need to create a chart from 2 columns, but not from all of the
cells in them.

For example:

If I need to create a line chart out of the date in colums A and D,
then I know that I should use Union to create a joint range of A and D
and pass it to to ChartWizard function.

But what I realy need is to create the chart out of A and D columns
data only if the data in column C for example, is "valid data" .

How can I do this?

Thanks!