Forum Discussion

Roinka's avatar
Roinka
Helper I
6 years ago
Solved

Special Matrix format

Hi,

I need to create the folloiwng matrix:

 

How can i create this formating when the header and left column are gray and the rest is white?

Thank you.

  • Outline color is under Grid and the border color us under border.

6 Replies

  • Hello Roinka 

    You can set those options under the Column headers and Row headers formatting.  You will also want to turn off Banded row style under Values

    • Roinka's avatar
      Roinka
      Helper I

      Thank you!

      Please note that in my example it has black frame at the top and a black line at the bottom. How can i add those?

      • jdbuchanan71's avatar
        jdbuchanan71
        Super User

        For the top, under column headers you can turn on the outline: bottom only.  I don't think there is a way to add one to the bottom of the table undless you turn on the border for the whole table.

         

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    In the Format pane, expand Style and set Style to None. Then expand Column headers and set Background color to your gray color. Then expand Row headers and set Background colors to your gray color.