Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Visio

I have an visio table/matrix . On the side are names and on top are week days . I want to color the matrix cell depending on the place where the person is . How can i do that ?
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Suppose the source table is like below.

     

    Use a Matrix to display data, and apply conditional formattingto "Values" rather than "Rows" or "Columns".

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-yulgu-msft thank you for your time . 

But let's supose the source table is not like that , because i don't have just one amount , but three and the values are not numbers but places/names . 

How do I formate it by color knowing that the copmarable value is just text ? 

And how can i make the usernames show on the table , even if there is no data about them ?

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Please provide some dummy data.

 

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-yulgu-msft
    Thank you very much for your help . I took your suggestion and I have decited to use just  simple Matrix . The point where i am a little stuck is : 

    If there is no data for a user , then the Name will not display in the matrix . Is there any way to change that ?