Hi all I had created a gantt chart with some data series. However, I need to modify it as in if I clicked one of its data cell, the bars relating to the will change it's colour and will revert to it's original colour when I click other cells. How can i design the vb code/macros for this? any examples? or can i post an excel file here?(my excel version is 2007)