7 Replies Latest reply: Sep 23, 2011 8:27 AM by Sunil Chauhan RSS

    Change chart axis label, keeping values for calculation

      Hi all !

       

      I have this set of data describing the Advancement of Projects and their associated current Phase.

       

      Project | Advancement | Phase

      Prj_1    |   2                 | Ph_1

      Prj_2    |   7                 | Ph_3

      Prj_3    |   5                 | Ph_2

       

      Based on these records, I've built a chart displaying my Projects and their Advancement in number (see attached screenshot).

       

      Question : Instead of display Advancement values on X-axis (see Attached Screenshot), I would like to display Associated Phase labels. Bars length still depends on Advancement values.

       

      Any ideas ?

       

      Regards,

      Julien