-
1. Re: Cell Back Ground Color
Stephen Rizzo Nov 28, 2018 8:23 AM (in response to indy poo)-
Testing v2.twbx 165.1 KB
-
-
2. Re: Cell Back Ground Color
indy poo Nov 28, 2018 9:20 AM (in response to indy poo)yes please share the workbook if possible,thanks!1
-
3. Re: Cell Back Ground Color
Stephen Rizzo Nov 28, 2018 9:33 AM (in response to indy poo)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.
-
4. Re: Cell Back Ground Color
indy poo Nov 28, 2018 11:04 AM (in response to indy poo)i see only the image , not the workbook.
Kindly check and repost if possible.Thanks!!Indy
-
5. Re: Cell Back Ground Color
indy poo Nov 28, 2018 11:06 AM (in response to Stephen Rizzo)i see the attachment now.Thanks.Appreciated
-
6. Re: Cell Back Ground Color
indy poo Nov 28, 2018 11:11 AM (in response to Stephen Rizzo)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!!
-
7. Re: Cell Back Ground Color
Stephen Rizzo Nov 28, 2018 11:14 AM (in response to indy poo)1 of 1 people found this helpfulUnfortunately no, you cannot apply conditional color coding on dimensions.
-
-
9. Re: Cell Back Ground Color
Stephen Rizzo Nov 28, 2018 12:20 PM (in response to indy poo)1 of 1 people found this helpfulYou 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.