Using Custom Colour Palettes

Data

Using Custom Colour Palettes

Tableau has the ability to recreate any colour by using the RGB colour model. By using this you can customise your charts and dashboards to match your corporate branding guidelines.

The chart below shows the top 5 BBC Television Channels by expenditure in 2012. It is using the default Tableau Colour Palette

To amend a colour in Tableau Desktop you can double click on a colour on the colour legend itself. This pops up the standard select a colour menu. If you now double click on the blue square next to a category, BBC 1 in this example, you can customise the colour by choosing a different colour, amending the gradient or by specifying an RGB code.

BBC2

The website colourlovers.com allows users to store custom colour palettes. I am using the BBC Worldwide Colour Palette in this example.

If we look at the colour we can see it has an RGB of 184, 31, 30.

BBC6

If we enter this into the cusom colour menu on Tableau and click OK we can assign this shade of red to BBC. Repeating this for each channel will give it a BBC ‘branded’ look.

This works fine for a one off chart, however it would be a laborious task if it were carried out on every visualisation built at the company. Whilst not available through the front end, Tableau does allow for the creation of additional custom colour palettes.

To do this you need to amend the Preferences.tps file which can be located in the ‘My Tableau Repository Folder’. The repository is by default found within the My Documents folder on a Tableau Desktop user’s machine.

Navigate to the Repository and right click on the preferences file. You can open the file in Notepad or any other text editor.

The file uses a standard xml format. To add a colour palette you can use the following syntax:

       

               #B81F1E

          

Each color needs to be entered within the ‘Color-palette’ section. Unlike Desktop this uses HTML Hex Codes. Each code needs to be prefixed with a #.

The completed file for the BBC palette looks like this:

BBC13

Once you have entered each of your colours you can save the preferences file. You will need to close and reopen Tableau for the new preferences to load. Now if you go to edit colours you will see a new colour palette listed in the dropdown with the colours you have just specified.

BBC9

The preferences file will need to be installed on all local machines for users to be able to use the palette during design. The colours will still appear on the visualisation if loaded on another machine but the palette will not be available.

Did you know that Microsoft Paint allows you to get the RGB for any pixel on an image? Simply load or paste an image in MS Paint and use the Colour picker (it looks like an eye dropper) to select a pixel and then choose ‘Edit colors’ which is right most on the toolbar to reveal the RGB codes for the selected colour.

More About the Author

Darren Evans

Assist Lead, EMEA
Hot Topics: Best Practices for Data Connections Working on the InterWorks Expert Hotline I come into contact with many clients every day assisting them with all aspects of their ...
Table Calculations – Why apply them ‘By Cell’ A question I was recently asked by an in training Tableau User was ‘Why would I apply a table calculation by cell?’. To answer this I ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072