How can I change color of bar graph based on value?

(1) Share

Report

Posted on by PaulVerdonschot

How can I assign colors to (dashboard) graphs based on value? My field has values of only 0 or 1 and my graph type is 100% stacked bar. For certain views CRM will assign 0=green and 1=red and for other views (different data) it will be 0=red and 1=green.

I want to set the color fixed so that it is always the same, which would save the end users a lot of confusion. I've looked through various ways of XML chart editing but have yet to find an answer. It seems to me that CRM has some sort of underlying algorithm based on the data by which it assigns the colors.

Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

CRMInnovation.com on at

Like (0)

Report
Copy link

Link copied!

Here is a link to a blog posting that will take care of your requirements. I won't repeat the steps here.

community.dynamics.com/.../how-to-edit-microsoft-dynamics-crm-2011-chart-category-colors.aspx

Was this reply helpful? Yes No
PaulVerdonschot on at

Like (1)

Report
Copy link

Link copied!

Thanks Jerry, you would think this is the answer however the problem is that CRM jumbles which of the values is displayed first in the graph (0 or 1), so by switching the color of the first and second that doesn't necessarily mean that 0 is now always displayed first and 1 second.

I'm looking for a way to say "if value is equal to 0 then display as red" and "if value is equal to 1 then display as green".

Not sure if that's even possible but just trying to see if others had the same issue?

Was this reply helpful? Yes No
Gylfi Aron 1,280 on at

Like (0)

Report
Copy link

Link copied!

I am having the same issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Paul,

You can guide with this link to modify the color of your bar graphs www.powerobjects.com/.../customize-colors-indynamics-crm-charts

Please let me know if this information was useful.

Was this reply helpful? Yes No
Jorge S on at

Like (0)

Report
Copy link

Link copied!

Hi,

did you ever find a solution for this?

Thanks

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

This seems to be the solution for a stacked column chart, however really struggling to get it to work on a simple bar chart

https://crmchartguy.wordpress.com/2013/02/24/specify-exact-colors-for-each-priority-in-the-microsoft-dynamics-crm-2011-case-chart/

Was this reply helpful? Yes No
Mahesh Variance 65 on at

Like (0)

Report
Copy link

Link copied!

HI,

is this possible to give me access via team viewer ?

Let me know

Thanks

Mahesh

Was this reply helpful? Yes No