2 Replies Latest reply: Mar 19, 2012 10:28 AM by ladunh80 RSS

    Adding Data Bar to Straight Table

      In an Excel Pivot Table I have added conditional formatting "Data Bar" to the data to make it look like the following:

      QVW.PNG

      Is there a way to add this type of data graph to straight table cells?

        • Adding Data Bar to Straight Table
          Hamish Imrie

          - Create a table via the Chart functions option (not a normal table but a chart table)

          - Create a expression to obtain the data as required.

                    - Then on the Expressions Tab.....

                                - Display Options  - select Linear Guage

                                  Then you will see a guage settings option button. YOu should be able to test with the various settings to get what you want here.

            • Adding Data Bar to Straight Table

              hamishimrie,

              This was something new that I learned but I need it to make a gauge based on the other values in the column cells. The values in the column are based on an expression sum(YTDPremium). I only see in the gauge settings that I can set the segment limits.