1 Reply Latest reply on May 8, 2012 2:13 PM by philmodjunk

    Charts with text on y axis

    tomo17

      Title

      Charts with text on y axis

      Post

      Is there a way that i can chart data using text ratings?  My data has a rating for each week according to performance ie good, average, bad.  I am hoping that i can have the x axis as a week number and then the y axis be a representation of the ratings.

       

      Is there a way to do this other than having the ratings be converted to a number in a calculation field ie good =3, average = 2 etc and have that charted?

       

      Many thanks for any assistance?

        • 1. Re: Charts with text on y axis
          philmodjunk

          What kind of chart and what version of FileMaker do you have? (charting was upgraded with the release of version 12.)

          Do you want 3 bars for each week, each showing the number of records with a Good, average and Bad rating (one bar for each rating type for each week).

          Or did you have some other type of chart in mind?

          Note also that my question assumes that the chart will count records with one rating per record. If this is not how you have structured your data, please describe the structure that you have.