How about showing the generated code?

Here's what I got from a simple test (using relative references as you
have):

ActiveCell.Range("A1:B17").Select ' recorded correctly
Charts.Add
ActiveChart.ChartType = xlLineMarkersStacked
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("D9:E25")
ActiveChart.Location Whe=xlLocationAsObject, Name:="Sheet1"

note that the "Source" parameter is not assigned a relative reference
and that the chart location will always be "Sheet1"

Try something like this:

Sub Macro1()

Dim r As Range
Dim s As String
Set r = ActiveCell.Resize(10, 10)
s = ActiveCell.Parent.Name

Charts.Add
ActiveChart.ChartType = xlLineMarkersStacked
ActiveChart.SetSourceData Source:=r
ActiveChart.Location Whe=xlLocationAsObject, Name:=s

End Sub


Tim.


"Ricki Miles" wrote in message
...
I am recording a macro in Excel XP that will select a range of data
and make
a chart. The data will always be ten rows and two columns. Since
the data
may start in different cells on different sheets, I would like the
macro to
be relative so that when I click a starting cell and then run the
macro, it
will select the data starting at the active cell. I have tried
recording by
first activating the starting cell I would like, then Tools, Macro,
Record
New Macro, clicking the relative reference button on the macro
toolbar, then
selecting the range of cells and creating the chart.

When I use this macro in any starting cell, it always charts the
data by
starting at the cell I was at when I recorded the macro. What am I
doing
wrong?

Thanks for the help,

Ricki