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.