Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MarkerBackgroundColorIndex = xlAutomatic
If I create a chart in my code and I do not specifically set the
MarkerBackgroundColorIndex for the series it is set to xlAutomatic by default. How can I extract the actual colorindex that excel chooses? Debug.Print ActiveChart.SeriesCollection(I).MarkerBackgroundCo lorIndex just gives me the code for xlAutomatic (-4105 I believe). Thanks The Doctor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MarkerBackgroundColorIndex = xlAutomatic
In a bog standard chart, xlAutomatic (-4105) colours for
series lines are applied in series order starting at with the colour assigned to colorindex 25. So the automatic colour, both for the line and markers in Series 3, where series 3 was the third series created, would (normally) be the same as #27. If a series is deleted and a new one added, the auto colour takes the first unused colorindex from #25 on. There are one or two other things that can contradict what I've described. With Bar type series and those that can be "filled", automatic colours start at #17. In a chart with a single series with "Vary colors by point", again automatic point colors are applied starting from #25. Regards, Peter -----Original Message----- If I create a chart in my code and I do not specifically set the MarkerBackgroundColorIndex for the series it is set to xlAutomatic by default. How can I extract the actual colorindex that excel chooses? Debug.Print ActiveChart.SeriesCollection (I).MarkerBackgroundColorIndex just gives me the code for xlAutomatic (-4105 I believe). Thanks The Doctor . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|