Excel Variable Charting

[baka_giraffe]

Hi, i got some datas whereby it will be a headache to read at them. It would be easier for me to look them in charts. I have done in vba in this way

Sub Chart2()
Dim yRange As Range
Dim xRange As Range
Set xRange = ActiveSheet.Range("O7:AC7")
Set yRange = ActiveSheet.Cells( _
ActiveCell.Row, 1).Range("O1:AC1")
With ActiveSheet.ChartObjects(1)
.Chart.ChartArea.Clear
.Chart.SetSourceData Source = Range("yRange +& xRange"), PlotBy:= _
xlRows
.Chart.ChartType = xlXYScatterLines
End With
End Sub

The problem is there is a runtime error of 1004, range of object _global failed
What i wanted is that

once i click on a certain cell, that row of cells will form a chart with x axis as o7:ac7, y axis as the row of cells found in column O:AC.

How else can i perform this?

 

[gehusi]

There is probably an easier way for you to accomplish this without using VBA. If you post a sample of your data we can probably apply some dynamic charting techniques to get the job done.

 

[baka_giraffe]

http://www.mediafire.com/?ntoincbka1qw3nj

here we go.. a sample of the data. Could you assist in teaching me dynamic charting? sorry being a noob here.

 

[baka_giraffe]

Upp upp... any1 else have any ideaS??

 

[gehusi]

As a clarification, a requirement for this request is that it use VBA.

 

[baka_giraffe]

Thanks! Solved!! =)