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?

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" <(E-Mail Removed)> wrote in message
news:CB6D37C9-CFF2-4B33-BE31-(E-Mail Removed)...
>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?

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" <(E-Mail Removed)> wrote in message
> news:CB6D37C9-CFF2-4B33-BE31-(E-Mail Removed)...
> >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?
>
>
>

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" <(E-Mail Removed)> wrote in message
news:64B0F0EE-315D-4BDC-A726-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:CB6D37C9-CFF2-4B33-BE31-(E-Mail Removed)...
>> >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?
>>
>>
>>