Salesforce Update: Set Colors for Picklist Values in Charts

Posted by Jay Rivard on Dec 8, 2009 3:41:00 PM

With Winter '10, you can assign fixed colors to picklist values when shown in charts. Charts based on those picklists will always show the same color for particular picklist values in all charts in reports and dashboards across your organization. For example, if your team creates the same chart for every month, you can make sure that the groupings are always shown in the same color.

The following figure shows a dashboard with three charts grouped by opportunity stages. Fixed colors were assigned to the Stage picklist values so that the "Closed Won" stage is always shown in green and "Closed Lost" in red. Notice that even though another stage appears on the second chart, the assigned colors remain the same.


Set Colors for Picklist Values in Charts in Salesforce

To assign colors to standard or custom picklist fields:

  • Navigate to the fields page for your object. For example, for account fields, click Setup ➤ Customize ➤ Accounts ➤Fields. For custom objects, click Setup ➤ Create ➤ Objects, then click the name of an object.
  • Click the name of the picklist you want to update.
  • Click Chart Colors and select an option to assign colors to picklist values for use in charts:
  • Assign fixed colors to all values assigns a fixed color to each value from the standard set of chart colors.
  • Assign colors to values dynamically assigns colors when a chart is generated. The Chart Colors column shows "Assigned dynamically" for all colors. Assign fixed colors by editing picklist values.

Note: Chart colors aren't available for multi-select picklists, currency picklists, or Task Subject, Event Subject, and Opportunity Competitor picklists.

  • To assign colors to individual picklist values:
  • In the Picklist Values section, click Edit next to a value.
  • In the Picklist Edit page, assign a color for use in charts by clicking the button. To assign a color dynamically when a chart is generated, click Assign color dynamically.
  • Click Save.

 CRM Best Practices

Topics:, Reports & Analytics