Gantt Chart Troubles

[natheplas]

Hi All,

I was hoping someone can help me with a Gantt chart I've made. I want the dates at the top to be from the dates the project is starting to finishing. However, they don't match my start date columns and then when I plot the remaining duration date it doesn't correlate to the project dates.

This is harder to explain and easier to see.

I've spent hours trying to work out what I am doing wrong?!

If I'm able to send it to someone on here somehow to have a look that would be really good.

I hope someone can help me and many thanks in advance!

Kind Regards,

Nathan

 

[PostTIT]

Column B - Task Event - Other axis (y-axis if you're doing a proper Gantt chart)
Column E - Start Date - Primary data
Column D - Original Duration - Secondary data (Or column K, I'm not sure which one you were using)

My advice is to delete the current chart that you have and start again:

- Insert stacked bar chart without selecting the data initially
- Click to select data, choosing just Column E. your other axis will automatically be 1,2,3,etc.
- Click to select data, choosing just Column D. Again about the other axis.
- In the select data window, select the 1,2,3,etc (not either of your data sets) and replace it with Column B - this should work for both sets of data.
- And it should work from that, you may have to alter the values on the date axis but that shouldn't be hard.

 

[natheplas]

Hi,

It's all sorted, I was using a workday formula which was messing up my days across the x axis.

So it wasn't the dates and how they were plotted, but the way the graph was plotting the data on the gantt chart.

Thank you for your replies and help though.