+ Reply to Thread
Results 1 to 3 of 3

make my gantt chart show every day of the month.

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    534

    make my gantt chart show every day of the month.

    I have built my gantt chart showing the task that are to be performed daily, weekly, and monthly but at the top where the dates are listed it is only showing me every 7th day or so. How do i set it to show me all the days of the month or in this case date range?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: make my gantt chart show every day of the month.

    Unless I am misunderstanding something:

    1) Go into the format axis dialog for the horizontal axis. You will see that the major and minor units for the axis are set to automatically and Excel has chosen 5 days for the major unit and 1 day for the minor unit. You can set these values to whatever you want.
    1a) To get an unlabeled tick mark at every day, leave the major unit and minor unit at 5 and 1 and format the axis to show minor tick marks.
    1b) To get a labeled tick mark at every day, change the major unit to 1.
    1c) To add minor gridlines, go to Chart tools -> Layout -> Gridlines -> Vertical gridlines -> show major and minor gridlines.
    1d) Whether you choose major or minor units/gridlines to represent 1 day, be sure to uncheck auto so that Excel will always leave this value as 1.

    Is that what you are trying to do?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    534

    Re: make my gantt chart show every day of the month.

    Thank you.

+ 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. [SOLVED] Would like to show days off in my Gantt chart
    By sinspawn56 in forum Excel General
    Replies: 11
    Last Post: 06-02-2016, 02:45 PM
  2. Replies: 5
    Last Post: 04-14-2015, 04:27 AM
  3. Macros color cells to make something as gantt chart
    By karbidas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2014, 09:22 AM
  4. [SOLVED] Gantt Chart: unable to set calendar month as x axis ?
    By niciwhite in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-09-2013, 03:53 AM
  5. how to make first of Month in y-axis on Gantt?
    By run4it in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-03-2009, 08:18 PM
  6. Replies: 1
    Last Post: 08-29-2006, 07:21 AM
  7. Replies: 2
    Last Post: 11-19-2005, 12:10 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