Hi there,

I have two columns A and B. I am plotting a graph which takes 100 rows of column A and B as its source data.

The data in both the columns changes with time. This results in fluctuation of no. of rows in which the data is available. So in one time only first 50 rows are there and rest are blank ..whereas sometime later only first 90 rows are there with the data and rest 10 are blank.

I don't want Excel to include these blank cells while plotting a graph.

How do I do that?

Please reply,

Kapil.