Using Excel charts for a yearly planning visual.

[StephW]

I currently have work catagories with dates set for planning work into the next year. Is there a way to utilize excel charts to utilize a visual chart? Each catagory has beginning dates and end dates that I would like to display on a yearly baseline.

 

[Andy Pope]

Hi,

Take a look at Jon Peltier's page on floating bars.
http://peltiertech.com/Excel/Charts/FloatingColumns.html

It also contains links to lots of other resources for doing gantt charts.

Cheers
Andy

 

[Jon Peltier]

Here's an article I wrote about simple gantt charts:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

And here's a list of resources on Gantt charts:

http://peltiertech.com/Excel/Charts/GanttLinks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______