Create Excel chart using C#

[Jeff Boeker]

Hello,

Where can one find the Visual Studio Tools for Office help file? I
downloaded the Visual Tools for Microsoft Office System 2003 and
didn't find the help file. I

Thanks,

Jeff

I could not find much documentation on step 4 above.
I am trying Workbook.Charts.Add(). Is there any good
documentation or sample C# code for this?

Hi,

I copied this straight out of the Visual Studio Tools for Office help
file:


// ---------
public void CreateChart()
{
Excel.Worksheet thisWorksheet;
thisWorksheet = thisWorkbook.ActiveSheet as Excel.Worksheet;
Excel.ChartObjects charts =
(Excel.ChartObjects)this.thisWorksheet.ChartObjects(Type.Missing);

// Adds a chart at x = 100, y = 300, 500 points wide and 300 tall.
Excel.ChartObject chartObj = charts.Add(100, 300, 500, 300);
Excel.Chart chart = chartObj.Chart;

// Gets the cells that define the bounds of the data to be
charted.
Excel.Range chartRange = this.thisWorksheet.get_Range("A5","D8");
chart.SetSourceData(chartRange,Type.Missing);

chart.ChartType = Excel.XlChartType.xlXYScatter;
Excel.SeriesCollection seriesCollection=
(Excel.SeriesCollection)chart.SeriesCollection(Type.Missing);
Excel.Series series =
seriesCollection.Item(seriesCollection.Count);
}

//----------

Peter

 

[Ahmed]

There is no help file, MSDN is where you will find all the information!
Refer to this website for the VBA reference.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/odc_ancoffice.asp