1 Reply Latest reply on Dec 4, 2018 1:44 AM by Norbert Maijoor

    Graph data using a non-numeric scale

    Colin Campbell

      I have a number of data fields within each record whose potential values are consistently scaled but are non-numeric.  Each field can have a value of insignificant, low, medium, high or critical.  I can convert these values to a numeric value and graph them, but I'd like to display on the y-axis their original values (insignificant, low, medium, high or critical) rather than 1,2,3,4 or 5. 

       

      What I want to achieve is a column graph that has (for example):

       

      Record 1; Field 1 - Critical

      Record 1; Field 2 - Insignificant

      Record 1; Field 3 - Low

      Record 2; Field 1 - Low

      Record 2: Field 2 - Low

      Record 2; Field 3 - Medium

      etc, etc.

       

      Does anyone know if there is a way I can either tweak the Y-axis so that it shows the relevant text, or graph the fields without converting them?