Converting Column Object to Line Object Issue

Hi there,

I've created an Excel 2007 application that automatically creates a chart based on input by a user. A feature of this application is that the user can specify if a data series is to be represented as a line object or column object when creating a Line-Column chart. The feature is available when the user want to update an existing Line-Column chart.

The problem is that when the user wants to switch from a column object to a line object, the corresponding colour of the object is not maintained. It seems like during the process of altering the data series chart type from column to line, MS Excel applies a generic colour. However, when the data series goes from a line object to a column object, there is no issue.

Does anyone have any ideas as to why this is happening?

Thanks.

Originally Posted by Andy Pope

How are you changing chart type?

The line should retain the column series Border colour as it's line colour.

Do you have Office SP2 installed?

I'm simply setting the series collection's chart type property from xlColumnClustered to xlLine. My tool's requirements specify that column objects should have no border, but I am reapplying the appropriate colour afterwards in a separate subroutine. I am running Excel 2007 SP2.

I have a subroutine called "SeriesColorAllocation" which assigns a client-specified list of colors to my data series objects (i.e., line, column, area) based on their position on the worksheet. The subroutine is called after the data series' chart object has been changed. The main color assignment logic is as follows:

chtActiveChart.SeriesCollection(i).Select
With Selection
If .ChartType <> xlLine Then
.Format.Fill.ForeColor.RGB = garrColorPalette(i)
.Border.ColorIndex = xlColorIndexNone
Else
.Format.Line.ForeColor.RGB = garrColorPalette(i)
End If
End With

The "garrColorPalette" array object stores the RGB values specified by the client.