0 Replies Latest reply: Apr 2, 2014 9:09 AM by Melissa van Kluyve RSS

    Change scatter chart axes points from numbers to text

      Hello QV gurus,


      I have a scatter chart that is meant to have the following fields as expressions: [% Complete] as x axis, [Area] as y axis and [$ Value] as Z/Bubble.


      The [Area] field has the following values: West, East, Central, Other. I could not get this field to work as my y-axis expression so have assigned a value to each, now using the [Rank] field in which 1 = West, 2 = East, 3 = Central, 4 = Other.


      The graph now appears as it should, though I'm not sure if I can change the [Rank] field to display the [Area] values along the y-axis? As in the below image, 4 would show 'Other', 3 would display as 'Central', etc.


      Thanks for your advice!