I'm trying to create a gantt chart use VBA. If I want the x axis to display something else other than the actual value. eg. when xlValue between 1-24 display 'Monday', 25-48 display 'Tuesday'... Can I do this?

TIA