Gantt Chart Date

[cotye]

I'm about to throw my desktop out the window.

Haven't used Excel in years and now my boss has asked that I produce a Gantt chart.. Given my computer doesn't have MS Project, I've resorted to using Excel.

So, I've got the data laid out in the following format. Description in the first column with start and end dates in Columns 2 and 3. The last column is duration
[TABLE="width: 833"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]
RFP Closing[/TD]
[TD]November 16-2016[/TD]
[TD]November 16-2016[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Optional Proposed Interviews[/TD]
[TD]November 28-2016[/TD]
[TD]December 2-2016[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Selection of Consultant and Award of Consulting Contract[/TD]
[TD]December 12-2016[/TD]
[TD]December 16-2016[/TD]
[TD="align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]

When I produce a stacked bar chart, I run into two issues:

i) X-Axis: Gives me dates for the year 1900. Nothing in the 2000s. For the life of me I can't figure out how to remedy this.

ii) Bar: Instead of giving me bars that 'float' in the middle of the chart signifying starts and ends, I get bars starting from January 00-00. Does solving problem i, solve my second issue? If not, how do I solve this?

Thanks for any advice!

 

[Perpa]

cotye,
Have a look at the link below and see if this helps. There are a couple of other links mentioned in there by other responders.
Perpa

http://www.mrexcel.com/forum/excel-questions/907676-gantt-chart.html#post4367768