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.