Excel VBA Guru's (Chart Object)

[Sforster]

Thanks HarryW,

The X-Axis values don't seem to be a problem, the major problem is with the values for the series and the name of the series.

I agree with the deleting and re-adding but when I add a new series, it uses my first value as the series name. I want to specify both separately.

i.e.

with activechart
  .SeriesCollection(1).delete
  .Seriescollection.Add Source:=Worksheets("DATA").Range("A14:A25")
end with

works fine except as mentioned above uses the first value (in this case the value in A14 as the Series Name)

I want to be able to specify the range for the values and the cell for the Name value.

Cheers
Steve