+ Reply to Thread
Results 1 to 1 of 1

Gantt Chart Change Timeframe

  1. #1
    Registered User
    Join Date
    03-28-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Gantt Chart Change Timeframe

    I'm using a gantt chart and would like to change the day columns for each month into weeks in each month. So instead of 1-30 under each month name I'd like to put 4 columns Week 1 -4. Any suggestions how how to change the formulas in this file to achieve this but keep the duration and conditional formatting working?

    Thanks!
    Attached Files Attached Files

+ 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] 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
  2. [SOLVED] Conditional formatting to change date text to Red within a certain timeframe
    By MarkyDee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2017, 11:30 AM
  3. [SOLVED] If cell has date within certain timeframe, change color?
    By shivers in forum Excel General
    Replies: 8
    Last Post: 06-24-2016, 08:09 PM
  4. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  5. Help Please!! Cell to change colour if timeframe exceeded based on several choices
    By Fran Habbitts in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2012, 05:56 AM
  6. Replies: 0
    Last Post: 07-13-2012, 06:40 PM
  7. Gantt Chart change of date
    By seanyeap in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-11-2008, 08:51 PM

Tags for this Thread

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