I'm trying top chart "Progress" of installations by client. As the stages of installations progress they get longer until they reach the end of the chart. I added the following equation to a hidden column to give each stage a numeric value: =IF(C4="New",1,IF(C4="Intro",2,IF(C4="Gather",3,IF(C4="Config",4,IF(C4="Testing",5,IF(C4="Secondary Testing",6,IF(C4="Processing",7)))))))


Screenshot(couldn't get image uploader working)
https://sli.mg/KE0ijo

I want to replace the numbers along the bottom with the corresponding stage of installation. The excel chart is simply set up as |Client|Stage|Stage#|


Thanks in advance