Creating a chart.

C

cmdolcet69

The code below creates a chart and places it on the Excel spreadsheet.
I can;t seem to find a couple of things how can I control what is
displayed on the x and y axis?
and how can I control how wide or how many points are displayed.


oChart = oWS.Parent.Charts.Add
With oChart
.ChartWizard(_ReadingArrayList3,
Excel.XlChartType.xlLine, , Excel.XlRowCol.xlRows)
'.ChartWizard(oResizeRange, Excel.XlChartType.xlLine, ,
Excel.XlRowCol.xlRows)
oSeries = .SeriesCollection(1)
'' oSeries.XValues = oWS.Range("A2", "A6")
''For iRet = 1 To iNumQtrs
'.SeriesCollection(iRet).Name = "=""Q" & Str(iRet) & """"
''Next iRet
.Location(Excel.XlChartLocation.xlLocationAsObject,
oWS.Name)
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with setting chart size in VB.NET 0
Reversing Dates Sequence along X axis in a chart 3
Creating an excel chart out of a splitted range with MFC Excelautomation 2
Anchoring a chart to a certain area 5
Interop Chart Series Error 1
Dual axis Chart 0
creating a secondary axis from stock chart 1
Problems trying to program a XYScatter chart in Word 0

Top