Announcements
No record found.
I know I can use PaletteCustomColors like this
<Chart Palette="None" PaletteCustomColors="Red; Green; Blue;">
Let's say there's a funnel chart with 3 stages (nurses, lawyers, doctors) and these will get following colors (red, green, blue). In case on funnel there are only 2 stages (nurses, doctors), colors will be (red, green). Please notice, doctors stage color changed from blue to green. Is it possible to assign specific color to one of these values? (eg. doctors will always get green, no matter how many stages there are on the funnel chart)
*This post is locked for comments
No, there is no supported way with charts to do this. You'd need to make a report instead. Which, if you want, you could embed the report into a Dashboard as a URL to emulate a chart.
Yes, you should be able to do this in a couple of different ways.
This post might help, although it is for a different chart type the same principles should apply:
crmchartguy.wordpress.com/.../specify-exact-colors-for-each-priority-in-the-microsoft-dynamics-crm-2011-case-chart
Actually, you can't use that approach with a funnel chart because it only supports a single series.
Alternative approach: create dummy records with zero values to make sure that there is always at least one record for every category in the dataset (you might need only three, or one for each category for each month, or owner, etc, depending on your real scenario).
Better alternative: use a single stacked column instead of a funnel (since a funnel chart is just a stacked column with pointless triangular wings to distract and confuse you - the data values are encoded as the heights of the slices only). Configure the category axis lines and label to be transparent so they don't show up. Optionally do the same for the value axis.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
JS-09031509-0 3
AS-17030037-0 2
Mark Eckert 2