Finally some time to post and finished my all-time longest bloging pause.
Mojca had to create Gantt chart last week in Word or Excel. Word seemed like a very bad idea so we chose Excel. First, we tried with draw a stacked bar graph with white and colored bars, but we gave up. One of the requisites was that x axis needed a break. In had to run from 1 to 45 and from 45 to 65, the x axis had a break from 45 to 65. We couldn't figure how to do that in Excel.
So Google had another idea. Create a Gantt chart in Excel using conditional formating. It worked great.
You can download sample Excel worksheet with a simple Gantt chart.