defining range is my plot problem
 

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?

defining range is my plot problem
 

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?

defining range is my plot problem
 

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" wrote:

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?

defining range is my plot problem
 

This example should show you how to solve the problem:

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

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


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

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?