+ Reply to Thread
Results 1 to 2 of 2

Gantt chart date range from random to monthly

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    Brisbane
    MS-Off Ver
    Office 365
    Posts
    1

    Gantt chart date range from random to monthly

    Hi,

    I've been provided this Gantt chart to use and I can't work out how to make the date range into 30 day increments
    I've looked through the X-Axis and I'm struggling to make it work.

    Is the template I've been provided just set up wrong?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Gantt chart date range from random to monthly

    Hello Muzza2 and Welcome to Excel forum.
    Perhaps if we could see the original setup of the horizontal axis along with some sample data in columns D:E we might be able to help with the bar chart.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Macro/VBA for hiding unhiding an unused date range in a Gantt Chart
    By stuwie666 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2022, 12:16 AM
  2. Replies: 5
    Last Post: 12-27-2021, 08:49 PM
  3. GANTT Chart - Mark cells within Date range
    By hennair in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2021, 11:42 AM
  4. Add monthly view to a GANTT Chart
    By Nexxion in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-21-2021, 11:14 AM
  5. [SOLVED] Have the ability to view a daily Gantt chart as a monthly gantt chart
    By adam_d_john in forum Excel General
    Replies: 3
    Last Post: 03-13-2018, 09:11 PM
  6. Excel Gantt Chart with Dynamic Date Range
    By helpme858 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2017, 06:59 PM
  7. Monthly gridlines in Excel Gantt chart
    By colabarris in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2016, 02:50 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