Hi,
I am trying to get to get the cell back ground color for the shapes.I have created a new field For Cell = If Req Qtr > Rel Qtr the SLC Status end
How do we get the cell back ground for the new cell for Cell field.Basically trying to color code the cell of the shapes which are Rel Qtr > Req Qtr.
Best ,
Indy
The workbook should have been attached to the previous post. Let me know if you have any issues accessing it - I can repost it if necessary.
i see only the image , not the workbook.
Kindly check and repost if possible.Thanks!!Indy
Hi Stephen,
Thanks for your help.
Is there any way i can get the different color coding conditionally to my Status Column of Status without affecting the other layout shapes.
Pl let me know.Thanks and appreciated!!
Unfortunately no, you cannot apply conditional color coding on dimensions.
Thanks so much,
i am trying to replicate the same on my workbook , i am unable to get the same color coding to the cell .
Is there any particular order to follow placing the fields or any formatting is needed.
This is your screen
Here is my view for the same fields in the layout.
You will want to fix the axis range so that it goes from 0 to 1. That way your bars should fill the whole cell.
Also in your bottom chart, the [For cell] field appears to have multiple values for certain cells (see DME - L1 SVP - Q4'19). You may want to tweak your formula to guarantee that each cell is assigned a single color.
