standardizing line chart colours

[LUCASM]

I have a report which is over 8 pages and contains many line charts about countries.
I am currently maunally setting each country to a specific colour on every line chart

Is there a way to do this once and then use some coding to make sure that the the chart lines are the same colour for each series (country)

I have 32 countries in each chart which the user can select and deselect to keep the chart meaningful, and its pretty tedious having to set this many colours each time

I can only use Format painter on the same page, not across different pages - unless I'm missing something!!!

[Idrissshatila]

Hello @LUCASM ,

try the format painter, you click on the formatted chart, then click on the format painter brush and then on the chart you want to format.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[LUCASM]

Hi @Idrissshatila 

I'm pretty sure that the format painter does not work across tabs.
When I have tried to do this on one tab as soon as I click on anothe the format painter function looses its ability to paste.