1 Reply Latest reply on Sep 1, 2016 7:42 AM by Andrew Watson

    How to Make Chart Axis be a Calculated Field

    Barry Sheldon



      In the attached workbook, I have created a chart which shows a value of a data series based on which day of the year the data series occurs.


      I am trying to make the X axis say "Jan" for days 1-30, "Feb" for days 30-60, "Mar" for days 60-90, but I'm at a bit of a hangup.  I can't figure out how to make the chart axis be a calculated field "TextDate".  Any ideas?