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
|