turn a chart

[lior03]

hello all
i built my self a code of a chart based on walkenbach book.
[VBA]
Range("A1:C6").Select
Charts.Add
ActiveChart.SetSourceData Source:=Sheets("typeA").Range("A1:C6")
ActiveChart.Location Where:=xlLocationAsNewSheet
ActiveChart.Axes(xlValue).MajorGridlines.Select
ActiveChart.PlotArea.Select
ActiveChart.ChartType = xlLineMarkers
ActiveChart.PlotArea.Select
ActiveChart.Location Where:=xlLocationAsObject, name:="typeA"

[/VBA]
how do i turn the chart around namely i want the x axis on the left instead of right.
thanks

[rory]

Hard to be sure without seeing your data and chart, but you probably need to specify the PlotBy argument of the SetSourceData method as the opposite of whatever you have currently. There is also no need to set the Location twice - just use the last one!

[paulked]

[VBA]ActiveChart.Axes(xlCategory).ReversePlotOrder = True
[/VBA]
Is this what you want?

Regards

Paul Ked

[rory]

Nice motto!