MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel Gantt Chart active cell colour

  Asked By: Michael    Date: Nov 03    Category: MS Office    Views: 1621

does anyone knows how to program a gantt chart such a way that when
I click a particular cell, the bars related to the clicked cell will
change its colour and will revert back to the original colour when
other cells are clicked.

I have written the sample file with gantt chart created but i'm not
really sure if i can post it



2 Answers Found

Answer #1    Answered By: Haru Tanaka     Answered On: Nov 03

If you want to post  your file  so others in the group can look at it, send it
direct to me (david at grugeon dot com dot au), or one of the other
moderators, not to the group and I will post it in the group files. Make
sure it does not contain any confidential information.

In principle the answer is that you would use the SelectionChange event for
the sheet to fire a macro when the cell  is clicked. It will fire every time
a new cell is collected so you would test to see if the cell was a relevant
one, then you would change the colour  for the particular range. How you
would do this would depend on how the chart  was constructed.

When providing more information, it would be helpful to say what version of
excel you are using.

Answer #2    Answered By: Jacob Evans     Answered On: Nov 03

oh the version that i'm using now is 2007 however i will convert it
into MS excel  2003 in near future

Didn't find what you were looking for? Find more on Excel Gantt Chart active cell colour Or get search suggestion and latest updates.