defining range is my plot problem

[Guest]

I have a sheet that contain x values pre-determined. My y values are
calculated from another sheets. I that sheet do not have data, then my y
value is in blank. I want to made a plot with the available data. My code
check which are the last row that contain data. I want to plot my data points
from cells(3,1) to cells(lastrow,1). How can I define the
seriecollection.xvalues in this case?

 

[Jon Peltier]

What kind of chart? Would all the missing values be at the end, or
interspersed?

- Jon

 

[Guest]

The Chart Type is xlLineMarkers. My x axis is period of time and my y axis is
the data obtained in the period. Depend of the test, the period of time o the
test can be change. For that reason, all the missing values will be at the
end because depend on the test long.

 

[Jon Peltier]

This example should show you how to solve the problem:

http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html

- Jon