+ Reply to Thread
Results 1 to 1 of 1

Merge Cells in Gantt Chart to form calendar view

  1. #1
    Registered User
    Join Date
    02-02-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    7

    Merge Cells in Gantt Chart to form calendar view

    Hi All,

    I am trying to create a 'calendar view' based on a gantt chart. I'm struggling with taking the first and last cell of the date range and merging those cells and all inbetween. Additionally, Ideally the contents of the 1st cell should be contents of the complete merged cells.

    I've also added conditional formatting which determines the start date and end date and creates the range of filled cells. Plus will color code the bars based on service type.

    Would appreciate any help anyone can provide?

    JayJacko
    Attached Files Attached Files
    Last edited by jayjacko; 05-05-2013 at 07:47 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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