Closed Thread
Results 1 to 2 of 2

Gantt Chart - Primary Horizontal Axis Doesn't Match Data - NEW

  1. #1
    Registered User
    Join Date
    11-29-2017
    Location
    newport
    MS-Off Ver
    MS Office 365
    Posts
    21

    Gantt Chart - Primary Horizontal Axis Doesn't Match Data - NEW

    Hi everyone,

    I use a Gantt chart for my work and today, I added a new date duration. Unfortunately, the Primary Horizontal Axis (the axis which shows the month) doesn't match what I have for the data. Please see attached.

    Example 1 - Under sheet "July 2018" you will see that under Project 4 - Scope out is due to start on 01/01/2019. Now, when you go to the Gantt Chart it suggests that the start date is actually passed already. It seems therefore that the date axis on the top of the gantt chart doesn't match the data that feeds into it.

    any help that anyone could give would be great

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Gantt Chart - Primary Horizontal Axis Doesn't Match Data - NEW

    You already have this request open and running here: https://www.excelforum.com/excel-cha...atch-data.html

    Duplicate threads are not allowed here, so this thread is now closed.

    Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Remember also that for many, this is still a holiday: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Gantt Chart - Primary Horizontal Axis Doesn't Match Data
    By cdhampshire in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-01-2019, 08:03 AM
  2. [SOLVED] Primary Axis & secondary Axis have high gap to show in chart
    By leakhna in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-05-2018, 02:19 AM
  3. [SOLVED] Why doesn't my chart pick up years as the horizontal axis?
    By elmasguapo in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2015, 06:33 PM
  4. change to chart primary horizontal axis label or name
    By pwynkoop in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 04-10-2013, 01:30 AM
  5. Replies: 2
    Last Post: 03-11-2011, 09:02 AM
  6. Replies: 1
    Last Post: 03-01-2011, 05:09 PM
  7. Replies: 6
    Last Post: 12-07-2010, 02:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1