Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Gantt Charts and Conditional Formatting

Status
Not open for further replies.

EliseFreedman

Programmer
Dec 6, 2002
470
GB
Hi There

I have created a spreadsheet with a project task list. The task list has start dates, end dates and project status. I now tried to create a gantt chart which i wanted to conditional format to At Risk, On Target, Overdue etc. However, all the options for formatting including conditional formatting are greyed out. I have tried creating a new chart, exporting the spreadsheet to another workbook but no luck

Has anyone got any suggestions
 
Hi,

In your chart source data, you must have a column of each color in your gantt chart and consequently, formulas to turn on/off the duration value in each column.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
 
Elsie,

I've uploaded a brief example, displaying
At Risk as [highlight #EF2929]RED[/highlight]
On Time as [highlight #4E9A06]GREEN[/highlight]
Overdue as [highlight #FCAF3E]ORANGE[/highlight]

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
 
 https://files.engineering.com/getfile.aspx?folder=34b0e2db-c5d3-4433-b8ac-56a67b36bf6e&file=tt-Freeman.xlsx
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top