Chart line colors "Pieter" <pieter[ at ]sanet.net> 3/9/2007 10:27:24 AM Hi I create a few charts in code from VB.NET using the excel interops, office 2003. In my software I need to be able to set the color of the lines i.e. the color of each series on the chart. There may b e up to 9 series per chart. How do I asign a color to the series lines? thanks

RE: Chart line colors jam96-BuffaloJoe 3/9/2007 9:10:11 PM Dim oSer As Microsoft.Office.Interop.Owc11.ChSeries = yourChartName.Charts(0).SeriesCollection.Add oSer.SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimSeriesNames, -1, sSeriesNameYourData) oSer.Interior.Color "Pieter" wrote: [Quoted Text] > Hi > > I create a few charts in code from VB.NET using the excel interops, office > 2003. In my software I need to be able to set the color of the lines i.e. > the color of each series on the chart. There may b e up to 9 series per > chart. How do I asign a color to the series lines? > > thanks > > >

RE: Chart line colors jam96-BuffaloJoe 3/9/2007 9:15:00 PM 'oSer.Interior.SetTextured(Microsoft.Office.Interop.Owc11.ChartPresetTextureEnum.chTextureGreenMarble) "Pieter" wrote: [Quoted Text] > Hi > > I create a few charts in code from VB.NET using the excel interops, office > 2003. In my software I need to be able to set the color of the lines i.e. > the color of each series on the chart. There may b e up to 9 series per > chart. How do I asign a color to the series lines? > > thanks > > >