+ Reply to Thread
Results 1 to 2 of 2

Gantt Chart issue

  1. #1
    Registered User
    Join Date
    05-06-2018
    Location
    Bradford
    MS-Off Ver
    2011
    Posts
    0

    Gantt Chart issue

    Hi ya

    Hoping someone can help me out. I have found a flaw in my gantt chart, as soon as i have multiple jobs starting on the same day the first client name comes up and not all the other client names.

    the chart is generated by a table which has been created by a small formula to get the dates in the correct order. the column name is start date

    the table layout is

    customer id, customer name, start date, finish date.

    the rest of the information is entered in via a vlookup formula based on the start date, and this is where i am having the issue of only getting one name even though there can be multiple names with the same start date.

    can anyone help me out with what formula i need to add, NO VBA PLEASE

    Ta much

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello dimples,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to 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 issue
    By davidstokes in forum Excel General
    Replies: 2
    Last Post: 04-19-2018, 10:31 AM
  2. [SOLVED] Gantt Chart + Issue with formula......URGENT
    By skyping in forum Excel General
    Replies: 2
    Last Post: 05-13-2015, 09:15 AM
  3. [SOLVED] Formula issue regarding date on gantt chart
    By rgholmes08 in forum Excel General
    Replies: 3
    Last Post: 08-05-2014, 04:27 PM
  4. [SOLVED] Gantt Chart Conditional Formatting Issue
    By rgholmes08 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-04-2014, 09:43 AM
  5. HELP Needed: Conditional Formatting Issue on Gantt Chart
    By JGlascott in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-10-2014, 11:08 AM
  6. Excel style gantt chart conditional formatting issue
    By Journeyman3000 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-13-2013, 04:06 PM
  7. Gantt Chart help needed to fix an data issue
    By smartcard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2010, 09:58 AM

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