Excel help.

[silva]

I have mapped out a schedule for a project in a bar chart.

I'm running into a problem where all my tasks are starting on the same date. The data points all start at the beginning of my year range. ex. June 1st.

I want the bar to reflect the correct start and end date and I'm not sure where my error is.

Any ideas?

[silva]

So for example.

Task A starts June 1 and ends June 15th.
Task B starts June 16 and ends June 30th.

Both of these tasks are graphed as starting June 1st.

[bearbaby]

If I'm understanding what you're describing, you essentially need a 'blank' column to build a waterfall so the bars stagger. You then make that "blank" column 'no fill' so it doesn't show and the colored bars will only stretch between the dates you want them (not from the beginning)

[silva]

May 28, 2015 15:51:59 GMT -5 bearbaby said:

If I'm understanding what you're describing, you essentially need a 'blank' column to build a waterfall so the bars stagger. You then make that "blank" column 'no fill' so it doesn't show and the colored bars will only stretch between the dates you want them (not from the beginning)

Thanks! Let me soak this in and test it out.

[bearbaby]

So you almost need like a 'blank/dummy' column to 'fill in' June 1-14 (in your example), and then the next column will start on June 15. You can right click individual columns to change their fill/formatting and there make it 'no fill' so you don't see it, making the June 15th column floating, essentially.

[hbomdiggity]

Do you not have ms project?

[silva]

May 28, 2015 16:04:28 GMT -5 hbomdiggity said:

Do you not have ms project?

nope.