4 Replies Latest reply: Jul 26, 2016 3:55 AM by Zhihong He RSS

    Apply Color map to all charts

    Suraj Kumar

      Hi Experts,

      I want to define a standard set of colors(bar chart properties-->colors tab->Data Appearance section) for all charts in the document.

      I clicked on Advanced button and defined some colors and tried to make it document default. But it seems that the changes(all set of colors) are not applied to all chart and are just stored as document default colors.

      How can i apply the change to all charts ie using document default color map.

       

      Thanks!

        • Re: Apply Color map to all charts
          Gysbert Wassenaar

          Changing the default document colors will not change existing objects. You'll have to do that manually. Perhaps the Format Painter Tool (from the Design toolbar) can help a bit with that.

          • Re: Apply Color map to all charts
            Chanty 4u

            Hi,

            try to create colour codes in excel sheet and load that in Qliview and try to insert below script  then u will get the same colurs whatevr u expected 

            chk below thread aswell

            Re:Load colour

             

            ColorCodes:

            LOAD ColorNo,

                 ColorCode

            FROM

            [$(vFilePath)\ColorCodes.xlsx]

            (ooxml, embedded labels, table is Sheet1);

             

             

            Let vNumberOfRows = NoOfRows('ColorCodes');

            For vI = 0 to (vNumberOfRows - 1)

            Let vVariable_Name = Peek('ColorNo',vI,'Expression');

            Let [$(vVariable_Name)] = Peek('ColorCode',vI,'Expression');

            Next

             

             

            DROP Table ColorCodes;

             

            NOte: ColourNo {1,2,3...}

            ColourCode{RGB(255,255,0).....}

              • Re: Apply Color map to all charts
                Suraj Kumar

                Hi Chanty,

                 

                Thanks for script.

                 

                My requirement is to apply the color changes to all charts at one go(because my dashboard has some 30 charts), instead of manually going to each chart(color tab-> Advanced tab-->update doc default).

                  • Re: Apply Color map to all charts
                    Zhihong He

                    Hi, Suraj,

                     

                    Yes, as Gysbert pointed out, the modified document default color will not effect the exist objects. So you know that you must set this value when you start to create the dashboard in the future.

                    And in your case, the  "format painter tool" helps.  Pls notice that you need to double click on the target object to make the format work.

                     

                    Zhihong