Share via

Excel Project Timeline

Anonymous
2020-04-30T16:44:33+00:00

I need a timeline and would like it to look like graphic 1.  Problem is my dates are not in chronological order and I don't want to change them on the source document.  So I thought I could do a pivot table, linked to the source document, sorted chronologically.  But I just can't seem to make it work.  Excel doesn't seem to act the same with the info is pulled from a pivot table.  Note, I'm not looking for a timeline slicer in a pivot table.  Any other suggestions for making a project timeline from a table that is not chronological?.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-04-30T18:10:19+00:00

    Hi,

    Sorry for the trouble caused at your end.

    Per your description, when I tested at our end by using the dates which are not in chronological order and inserting the timeline chart, the dates are arranged in a chronological way by default.

    But changing the Axis type to Text axis will have the same representation as to the data selected:

    Click on the X-axis> Right-click> Format axis> Axis options> Text axis.

    Appreciate your patience and understanding. Have a good day and stay safe 😊

    Best Regards,

    Chitrahaas

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-05-01T08:44:13+00:00

    Hi aminionheir,

    I go through the post carefully. there are some Timeline template that may help you build the timeline quickly, you Can find them in File>New>type Timeline in Search bar

    Additionally, I’d like to know how do you create the timeline in screenshot? here is a third party article that may help you: How to Create Timeline Chart in Excel Quickly and Easily

    ***Disclaimer:***Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

    As for the issue, if it is convenient to you, could you please share the workbook with us via private message? So that I can check if I can repro the issue.

    Regards,

    Clark

    0 comments
  3. Anonymous
    2020-04-30T20:32:30+00:00

    So what am I doing wrong?

      I've tried it as a scatter chart and as a bar chart.

    0 comments
  4. Anonymous
    2020-04-30T20:24:50+00:00

    Hi,

    No need, I've done the test again by placing the dates in the middle of the data:

    Best Regards,

    Chitrahaas

    0 comments
  5. Anonymous
    2020-04-30T19:21:21+00:00

    Does the date have to be in the left-most column?

    0 comments