Conditional Formatting in Graphs/Charts

Hello,

I am working on a project that requires conditional formatting for a graph, such as orange for bottom 10 products and blue for the top 10 selling products. Is it possible in Anaplan or is there any workaround for this? Please see the attached picture for a sample graph I want to create. Thanks

Accepted answers

All comments

SriNitya

Hi,
You can create 2 separate graphs to display top and bottom 10 products sold, in chart card you can configure the colors. Similar graph as in your image is not possible.

devrathahuja

@HarunT - Hi,
If you want to show it all in 1 graph, you can create 2 line items & then use different colors in the chart settings.

Line item 1 (Bottom 10) - Have a formula as If bottom 10 then value else Divide(0/0)
This would give a NAN for the line item for other cases & not be shown in the chart.

Same for Line item 2 & then publish both on the chart & set line item 1 color as blue & the other one orange

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385