lior03
08-22-2007, 06:09 AM
hello all
i built my self a code of a chart based on walkenbach book.
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"
how do i turn the chart around namely i want the x axis on the left instead of right.
thanks
i built my self a code of a chart based on walkenbach book.
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"
how do i turn the chart around namely i want the x axis on the left instead of right.
thanks