The situation:
- I have a worksheet called "ANC Data" with data in it.
- Using VBA, I want to plot K1:AK1 against K20:AK20.
- I have an independant chart (not a chart object in a worksheet) called "F14"


I want to change the x and y ranges for the series on the chart. These lines does not work:

Sheets("F14").SeriesCollection(1).XValues = "='ANC Data'!K1:AK1"
Sheets("F14").SeriesCollection(1).Values = "='ANC Data'!K20:AK20"

However, this line (which I used as a test) DOES work:
Sheets("F14").SeriesCollection(1).XValues = "={5,5,5,5}"

Anyone know what's going on?

10/5/2007 1:20:19 PM

Google offers no help.

10/5/2007 1:21:06 PM

Nm. Got it. Pays to be awesome.

10/5/2007 1:39:01 PM

howd you do it?

10/5/2007 1:41:03 PM

Sheets("F14").SeriesCollection(1).XValues = Sheets("ANC Data").Range(Sheets("ANC Data").Cells(1, 11), Sheets("ANC Data").Cells(1, 37))


It's a mess, but it works.

Actually, when I try to run it a second time, specifying a new range, it does not work. It appear that it (VBA in Excel) cannot overwrite anything...

10/5/2007 1:43:05 PM