Gantt chart colour change
I have created a gantt chart using a stacked bar chart and hiding the first
series. The tasks also have a different priority. Is htere a way I can use VB to change the colour of each task bar depending on the priority. I have 3 prioritys, either high medium or low. Thanks |
Gantt chart colour change
On Wed, 25 Apr 2007, in microsoft.public.excel.charting,
Bill Gates said: I have created a gantt chart using a stacked bar chart and hiding the first series. The tasks also have a different priority. Is htere a way I can use VB to change the colour of each task bar depending on the priority. I have 3 prioritys, either high medium or low. Why would you resort to VBA, instead of simply having three data columns? -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Gantt chart colour change
It is in one column because it is linked to a list in a share point site so I
can't mess with the formatting as it would mess up the list in share point. "Del Cotter" wrote: On Wed, 25 Apr 2007, in microsoft.public.excel.charting, Bill Gates said: I have created a gantt chart using a stacked bar chart and hiding the first series. The tasks also have a different priority. Is htere a way I can use VB to change the colour of each task bar depending on the priority. I have 3 prioritys, either high medium or low. Why would you resort to VBA, instead of simply having three data columns? -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Gantt chart colour change
On Wed, 25 Apr 2007, in microsoft.public.excel.charting,
Bill Gates said: "Del Cotter" wrote: I have created a gantt chart using a stacked bar chart and hiding the first series. The tasks also have a different priority. Is htere a way I can use VB to change the colour of each task bar depending on the priority. I have 3 prioritys, either high medium or low. Why would you resort to VBA, instead of simply having three data columns? It is in one column because it is linked to a list in a share point site so I can't mess with the formatting as it would mess up the list in share point. That's what helper columns are for. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Gantt chart colour change
The helper columns are set up to have either zero value or the value of the
original column if the condition is met. See this Conditional Charts tutorial: http://peltiertech.com/Excel/Charts/...nalChart1.html It might also be helpful to see how to show percent complete using two series, one each for complete and incomplete: http://peltiertech.com/Excel/Charts/GanttChart.html Imagine bars where one or the other of incomplete/complete are zero. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Del Cotter" wrote in message ... On Wed, 25 Apr 2007, in microsoft.public.excel.charting, Bill Gates said: "Del Cotter" wrote: I have created a gantt chart using a stacked bar chart and hiding the first series. The tasks also have a different priority. Is htere a way I can use VB to change the colour of each task bar depending on the priority. I have 3 prioritys, either high medium or low. Why would you resort to VBA, instead of simply having three data columns? It is in one column because it is linked to a list in a share point site so I can't mess with the formatting as it would mess up the list in share point. That's what helper columns are for. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com