Palettes

When creating charts in Dynamics CRM, CRM creates a custom palette. However, it is the same custom palette that is being used on all you charts. So when you have dashboards with charts displaying data from different entities or different types of data, it can be difficult for the user to tell the information apart when everything is red, green and blue.

Fortunately it is fairly easy to export the charts xml file and modify it to display different color schemes, or Palettes as they are called. The Palette settings can be found right in the beginning of the presentationdescription. A quick search for “Palette” in your favorite xml editor (mine is Notepad++) will help you find it.

To apply a Palette, delete the cusot colors and replace “None” with one of the available Palette names. Before we start changing things, there a couple of things that are good to know about Palettes

  • They contain 16 colors – if you have more than 16 series in a chart, the colors start repeating after 16
  • The custom palette that CRM adds to charts have 12 colors
  • If Palette is “None” and there are no custom colors, then the Palette “BrightPastel” is used
  • If Palette is used, it will take precedence over your palette custom colors

Palette Options

The 12 different palettes available can be found here http://msdn.microsoft.com/en-us/library/system.web.ui.datavisualization.charting.chartcolorpalette.aspx

The options available are

  • Bright
  • Grayscale
  • Excel
  • Light
  • Pastel
  • EarthTones
  • SemiTransparent
  • Berry
  • Chocolate
  • Fire
  • SeaGreen
  • BrightPastel (the default if set to “None”)

Unfortunately Microsoft doesn’t seem to provide a graphical overview of the colors included, so here’s some samples to give you an idea of the color schemes.

The series is numbered 1-9 and are sorted in the same order. Meaning series 1 is the first color awarded etc. I am using a stacked column chart which shows the series in reverese order. Not sure why that is the default setting for a stacked chart. I figured 9 colors was enough to get an idea of what the palette looks like.

Standard Dynamics CRM custom palette for column charts

You are probably familiar with this color scheme by now.

Bright

GrayScale

Interesting that this is the only Palette that features a scale that gradually increases from light to dark. This might have been useful with other colors too.

Excel

But WHY!!!!! – Well, if you really like the Excel color scheme.

Light

Pastel

EarthTones

SemiTransparent

If you look closely you can see the gridlines though the columns. This may be more interesting to use on area charts or radar charts.

Berry

Chocolate

Fire

SeaGreen

BrightPastel (the default if set to “None”)

Advertisements

, , , , ,

  1. #1 by CRMDvlpr on February 20, 2014 - 7:50 am

    Hi
    I need your help regarding some properties on Chart Series !

    I am a defining a series like this :

    This works fine as per I want.

    I want to set a customPalette on Series. How can I do that ?
    I know I can do that by setting Palette=”none”. But how can I define color scheme for paletter Custom colors ?

    2. If I try for msdn, all the documentation seems to be relative to SSRS rdl files. And I noticed that CRM chart visualisation properties are different than SSRS design properties. Where can I find proper documentation on this ?

    Thanks a lot !

  2. #4 by Marea on September 8, 2015 - 6:36 pm

    This is fab- we can set palettes for individual charts; thank you.
    Is it possible to change the default for all charts at a system level (dynamics crm) rather than individual chart level?
    We look forward to your advice.

  1. Bubble Charts in Dynamics CRM | crm chart guy

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: