Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining series range for named range | Excel Programming | |||
Defining a range | Excel Programming | |||
Syntax problem defining range for pivot table | Excel Programming | |||
Defining range | Excel Programming | |||
Defining a range | Excel Programming |