+ Reply to Thread
Results 1 to 7 of 7

Monthly only gnatt chart

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Monthly only gnatt chart

    I'm trying to create a monthly only gnatt / bar chart.
    However, =IF(AND($F6>=$D7,H$6<=$E7),"") formula does not correctly work with the months

    I'm pasting the start and finish dates from another table, so I'M removing the days to only show the month.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Monthly only gnatt chart

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Monthly only gnatt chart

    I'd also change the formula to
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and in Cf use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    You can then get rid of the CF rule

  4. #4
    Registered User
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Monthly only gnatt chart

    Cheers, I tired that orignallly. However now, Jan is coloured. Dec is not in row 16?
    Any ideas :-)
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Monthly only gnatt chart

    Your column references are off by one and the formula wasn't quite right.
    In F16
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Monthly only gnatt chart

    Just the ticket! Thank you for your help :-)

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Monthly only gnatt chart

    You're welcome & thanks for the feedback

+ 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] HELP!!! I need Gnatt chart/table help I think
    By Kory95670 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-04-2013, 11:21 AM
  2. Gnatt Chart download in 2010
    By AlanC in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-29-2012, 05:19 AM
  3. Gnatt chart - Need help with Ifand formula
    By Kristina1976 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2011, 02:05 PM
  4. Gnatt chart - highlighting cells in different colour
    By Kristina1976 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2011, 01:20 PM
  5. Still need help with Color start and end dates on Gnatt chart"
    By Kristina1976 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2010, 12:39 PM
  6. [SOLVED] Stacked bars in a gnatt chart
    By Gnatt in forum Excel General
    Replies: 1
    Last Post: 08-01-2006, 03:35 PM
  7. gnatt chart in excel?!
    By meris in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2006, 10: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