Thread: Color Index
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Color Index

Typo

From colorindex 17 in the order the series were added,
typically the order the series were added.


would make more sense written as:

From colorindex 17 in the order the series were added,
typically series index + 16

Peter T

Hi Bill,

In a typical chart, Excel automatically applies colours to fill'able type
series "same as" the colours in the 6th row of the palette (not shown in

the
dropdown palette). From colorindex 17 in the order the series were added,
typically the order the series were added.

Eg, the xlAutomatic (-4105) fill colour for the third series will be "same
as" colorindex 19.

Depending on the chart, or what you have done to the chart, this rule may
not always apply. Eg, try deleting series #2 of #3, then add a new series.

Regards.
Peter T