Hello,

I have a table in excel with names and values based on the i made a bar graph. Now in every week i have to change colour of 1 bar of my choice. But that change in colour does not depend on value in the table. So i want to know is there any other way through which colour of a specific bar cab be changed automatically. For example if i bold or itaclic a perticular cell in the rable so the colour of the bar related to that perticulr cell should change.

Thanks