1 Reply Latest reply: Dec 13, 2013 8:58 AM by Friedrich Hofmann RSS

    Chart with fix x-axis

    Stefan Fischer

      Hi,

       

      with list boxes that can be controlled diagram. In the x -axis I want a fixed time radiating from October to September in x-axis. In addition it should be displayed in the x-axis label mon and year like attached png.

       

      Regards

      Stefan

        • Re: Chart with fix x-axis
          Friedrich Hofmann

          Hi Stefan,

           

          I don't quite understand why you'd want to fix your x-axis, but never mind: That timeline from Oct_this_year to Sep_next_year:

          You'd need a mapping table to do that where you use

          - a field generated with the MONTHNAME() function (that'll return you sth like 'Oct-2013')

          - a (handwritten) field "month_1", "month_2" etc.

          => You could then use the field generated through the ApplyMap() function as dimension to your chart.

           

          HTH

           

          Best regards,

           

          DataNibbler