afriendtln
New Member
- Joined
- Jan 12, 2005
- Messages
- 35
Hello,
I have created a gannt chart in excel and have basically 4 series of data in a stacked bar chart.
The first series is hidden 2nd series is cost, 3rd series is duration, and 4th is health. I would like to be able to format to a specific color the 2nd and 4th series based on the value of that data point. I can set the value in the cell for the cost to a specific number and let that represent a color (4 different colors are needed on 2nd series)(3 colors on health). Can you assist in providing steps to help with this? If it involves VB script provide detailed info on where to add the code please.
Thanks
Terry
I have created a gannt chart in excel and have basically 4 series of data in a stacked bar chart.
The first series is hidden 2nd series is cost, 3rd series is duration, and 4th is health. I would like to be able to format to a specific color the 2nd and 4th series based on the value of that data point. I can set the value in the cell for the cost to a specific number and let that represent a color (4 different colors are needed on 2nd series)(3 colors on health). Can you assist in providing steps to help with this? If it involves VB script provide detailed info on where to add the code please.
Thanks
Terry