Chart Showing Text within a Month

[jdj1907]

Hi,
I've been searching through forums and trying (in vain) many ways to create a chart (Using Excel 2010) that displays a Project name on one axis, a project milestone on the other axis and the month as the 'value'.

This may be asking Excel to do too much but basically I have a series of projects ongoing which I have to create a report for every month, this needs to be an 'easy to see' overview of the key milestones in coming months.
I.e. This would show that in January I have 3 key milestones coming up; two projects initiating and 1 project starting the second phase.

I've included an example of the chart I have if its any help
- Also, I know this would be sorted in MS Project but I don't have the luxury of that software

	Project 1	Project 2	Project 3
Project Start	January	February</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP>	January
Project Second Phase <TBODY> </TBODY><COLGROUP><COL></COLGROUP>	March</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP>	March</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP>	January <TBODY> </TBODY><COLGROUP><COL></COLGROUP>
Project End</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP>	June	April</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP>	February </SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP>

<TBODY>
</TBODY>

 

[sijpie]

OK you have included a table with the data. But what should the chart look like? Have you got an image (or link to image on internet ) of such a graph? Post your image on a sharing site and put link here (if you wrap it in