Gantt chart with labels

From: Randhir (Randhir_at_discussions.microsoft.com)
Date: 03/02/05

  • Next message: anonymous_at_discussions.microsoft.com: "Re: Custom charting - Stacked charting with a line" 
    Date: Wed, 2 Mar 2005 12:37:06 -0800

    Hi - I am using Excel to create gantt charts by following the very helpful
    instructions at:
    http://office.microsoft.com/en-us/assistance/HA010346051033.aspx. I am
    struggling on two parts though:

    1. How do I get the completion dates to show up on the bar? Just turning on
    labels shows me the number of days not the date in the above example.

    2. The month/time scale does not work for me - by setting the major step to
    30 or even 61, the months start off fine - with jan 1, etc, but later through
    the year, it goes off due to the difference in the number of days each month
    resulting in Jan 1, Feb 3, Marc 6, etc. How do I get it to consistently show
    the 1st of each month.

    Thanks in advance for your suggestions.

  • Next message: anonymous_at_discussions.microsoft.com: "Re: Custom charting - Stacked charting with a line"

    Relevant Pages

    • Re: Reference to free-form textboxes
      ... I tried your two statements in Excel 2007. ... > My instructions were for a text box like the one you are using. ... >>> back and forth between Design Mode and Normal Mode ... >>> 4) Press Textbox to view properties ...
      (microsoft.public.excel.programming)
    • Re: Explorer Issue, wont open new window or search
      ... I followed the instructions in this article for Windows ... it not only fixed the Excel issue but also corrected the issue I was having ... someone else experiences the same issue where Internet Explorer browser does ... > Blocking Spyware, Adware, Parasites, Hijackers, Trojans, with a HOSTS file ...
      (microsoft.public.win2000.general)
    • Re: Explorer Issue, wont open new window or search
      ... I followed the instructions in this article for Windows ... it not only fixed the Excel issue but also corrected the issue I was having ... someone else experiences the same issue where Internet Explorer browser does ... > Blocking Spyware, Adware, Parasites, Hijackers, Trojans, with a HOSTS file ...
      (microsoft.public.windows.inetexplorer.ie6.browser)
    • Re: Date axes in Excel 2003 and 2007
      ... Yes I am new to 2007 and I am struggling with the new ... that original object oriented Excel was incredibly well designed, ... Is Microsoft considering to redo Excel as .NET calsses ... Jon Peltier, Microsoft Excel MVP ...
      (microsoft.public.excel.charting)
    • Re: Rejection
      ... Is XP still saving the problem spreadsheet as a Excel ... instructions. ... The changed file name was my own idea and did not work either. ...
      (microsoft.public.office.misc)