Change fill color of a pie chart series in Access
05:05 01 Oct 2023

I have a chart based on this query.

SELECT IDtrattativa, NomeCognome, [Ricavi] AS Valore, "Redditività" AS CostiRicavi FROM qryAnalisiOperazione
UNION
SELECT IDtrattativa, NomeCognome, [costi], "Costi" FROM  qryAnalisiOperazione;

It is a series, and this is what I get.
enter image description here

I want to change colors in the series (costi should be red and ricavi should be green).

I tried this code in open (then I tried in load event).

With Me.CostiRicaviGR.ChartSeriesCollection.Item(0)
    .BorderColor = RGB(123, 222, 100)
    .FillColor = RGB(200, 300, 111)
End With

Nothing happens.

vba ms-access charts pie-chart color-scheme