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 ?