7 Replies Latest reply: Jun 27, 2014 1:00 PM by shalani kumarajeewa RSS

    customizing tables

      hi

       

      is there any possibility in customizing pivot or strait tables??

      1. i want to give a separate color to each column in an table...

      2. i want to make the headings (or column names) of three columns one color and the other 3 headings another color

       

      i know there are different styles in the style tab.. but it dose not do my requirement...the below image is an example how i want the table to look like

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      if some one can help me in this matter i would really really appreciate it thank you in advance

        • Re: customizing tables
          Mikael Kristensen

          Workaround, if nothing better comes up: Did you try to take advantage of the "Cell Background Color Transparency" under style?

          Then you could either put a background picture, with the colours if you can make it fit or use coloured blank text objects behind, if the table is permanent placed.

          • Re: customizing tables
            Greg Williams

            Settings > User Preferences... > Design > check Always Show Design Menu Items > OK

            Go to the table object > right click on the cell > Custom Format Cell...

            Also, one can navigate to Chart properties > Style > many options.

            • Re: customizing tables
              John Cavoulas

              Hi Shalani,

               

              Using a few different methods you can...

               

              As mentioned, make sure Settings > User Preferences > Design > Always Show Design Menu Items is checked. This allows the 'Customer Format Cell' option. Right click the desired column (under the header...not the header itself) and select 'Custom Format Cell', then set the color to the color desired. Apply to 'Current Dimension' only. Do this for all the columns.

               

              For the header, also as mentioned, you need to make the header transparent and place a text box with the desired color behind it. Go to the 'Style' tab and select 'Background'. Set the 'Color Transparency' to 100%.

               

              You will need to play with the size and location of the colored text boxes as well as ordering the objects from top (chart) to bottom (colored text boxes).

               

              Here is an example of this...

              Table Colors.bmp

              I do not think it is possible to do anyother way unless it can be done via expression, and I haven't had luck with that.

               

              HTH,

              John

              • Re: customizing tables
                Greg Williams

                Shalani - Please mark Correct or Helpful to close the thread out. Thank you.

                • Re: customizing tables

                  sorry every one for the late reply thank you sooo much for all the help really really appreciate it thank you soo much