Posted to microsoft.public.excel.programming

anamarie30 anamarie30 is offline

external usenet poster

Posts: 26

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Defining series range for named range	Barb Reinhardt	Excel Programming	1	August 3rd 06 09:00 PM
Defining a range	Jonathan	Excel Programming	3	June 28th 06 06:11 AM
Syntax problem defining range for pivot table	Richard	Excel Programming	0	March 14th 06 06:52 PM
Defining range	Edgar[_3_]	Excel Programming	2	February 17th 04 02:24 PM
Defining a range	Matt	Excel Programming	3	January 23rd 04 03:21 PM

All times are GMT +1. The time now is 05:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us