Forum Discussion
standardizing line chart colours
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!!!
2 Replies
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 👍
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.
