Find a design for the matrix

[amirabedhiafi]

How can I create this design for a matrix ? :

[Mikelytics · Accepted solution]

Hi @amirabedhiafi 

You can find the databar formating option here. Please make sure that you have your values formatted as numbers or percentage upfront. Otherwise it will not appear.

Then make the configurations as you need.

Please use as a visual a matrix with the following configurations.

Best regards 

Mikelytics

---------------------------------------------------------------

Did I answer your questions? Please mark my post as solution.

Appreciate your Kudos.

 

[amirabedhiafi]

and if I want to have a specific databar formating for each column of my matrix what should I do ?

[Mikelytics]

Hi @amirabedhiafi,

looking on my pictures you can see that I execute the steps for one specific column / value . So you can execute this steps several times for each value individually.

Best regards

Mikelytics

--------------------------------------------------------------------------------------------------------------

Did I answer your questions? Please mark my post as solution.

Appreciate your Kudos.

[VijayP]

@amirabedhiafi  You can use Databars for the Values in Conditional formatting! and For headings you can create a Text box or Shape with Text box. Try and let me know! 

Please share your Kudos and if this satisfies your requirement please mark this as solution

Vijay Perepa