Discussion:
Chart line colors
(too old to reply)
Pieter
2007-03-09 10:27:24 UTC
Permalink
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
jam96-BuffaloJoe
2007-03-09 21:10:11 UTC
Permalink
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
Post by Pieter
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
jam96-BuffaloJoe
2007-03-09 21:15:00 UTC
Permalink
'oSer.Interior.SetTextured(Microsoft.Office.Interop.Owc11.ChartPresetTextureEnum.chTextureGreenMarble)
Post by Pieter
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
Loading...