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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"anamarie30" wrote in message
...
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?