I have the following bit of code in a larger macro, that plots column B
along the X axis and C along the Y axis. I'd really like it to switch the
axes so that it's C on the X and B on the Y. Changing the actual columns
isn't really an option...

Charts.Add
With ActiveChart
.ChartType = xlXYScatter
.SetSourceData Source:=Sheets(bcbsheet$).Range("B:C"),PlotBy:=xlC olumns
.Location Whe=xlLocationAsNewSheet
.Name = "some text"
.HasTitle = True
.ChartTitle.Characters.Text = "some text" .Axes(xlCategory,xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle= False
End With

Any hints on how to "fix it"?

Bruce

--
+-------------------+---------------------------------------------------+
Bruce Bowler | Human beings are the choices they make under
1.207.633.9600 | pressure. - Bob McKee
|
+-------------------+---------------------------------------------------+