Adding Data Bar to Straight Table

[#1]

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

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

[Anonymous]

- 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.

[#3]

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.