About Us

Don Guillett

In which group would you like an answer?
--
Don Guillett
SalesAid Software

"SPV" wrote in message
oups.com...
I was trying to plot the Scatter graph for a specified range in
different columns. I have 3 columns with specified ranges Col 1 X axis
and the col2 and 3 plotted on Y axis . I have generated a record macro
for the same and it look like the same below.

Range("A2:A14,E2:E14,H2:H14").Select
Range("H2").Activate
Charts.Add
ActiveChart.ChartType = xlXYScatterSmooth
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range( _
"A2:A14,E2:E14,H2:H14"), PlotBy:=xlColumns
ActiveChart.Location Whe=xlLocationAsObject, Name:="Sheet1"
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "ARM Load"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Time
in Sec"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Load in
%"
End With
End Sub

I have already defined ranges for
A2:A14 = Range 1
E2:E14 = Range 2
H2:H14 = Range 3 by declaring them as range...

Now when I gave Range("Range1,Range2,Range3").Select = didn't work
for me...
I tried Range("Range1","Range2","Range3).Select also.. didn't give me
result...

Now I tried Union(Range(X_axis), Range(NULL_Thread_activity),
Range(NULL_Thread_activity)).Select

Please throw some light on how to program the same in VBA with
specified ranges and not taking explicit cell references...

Thanks in advance for helping me....

Regards,
SPV

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I feel so dumb - please help - this is a Range issue	Cat	Excel Worksheet Functions	4	May 31st 07 11:48 PM
Identifying a selection of a selection of a range	swimfast	Excel Worksheet Functions	1	March 1st 07 02:51 AM
Strange named range issue with multiple workbooks	Adam White	Excel Discussion (Misc queries)	0	November 14th 06 02:34 AM
Range Selection	cfspahn24	Excel Discussion (Misc queries)	3	April 14th 06 01:29 PM
Selection Range	ch	Excel Discussion (Misc queries)	5	July 15th 05 05:50 AM

Menu

About Us