Results 1 to 3 of 3

Thread: Visual Plotter basis given dates and activity

  1. #1
    Member
    Join Date
    Aug 2011
    Posts
    92
    Rep Power
    14

    Visual Plotter basis given dates and activity

    Hi,

    Need code to publish a plotter basis given dates and activity. In the attached file, Main sheet contains the dates and activity and the Plotter is a visual view of main sheet.

    Thanks
    Rajesh
    Plotter.xls

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    The plotter you have shown is not matching with what you have in your main sheet. Please ramify and post a correct expected output.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member
    Join Date
    Aug 2011
    Posts
    92
    Rep Power
    14
    Plotter 1.xls
    Hi,

    I found one way to do it. First add 2 more column after each activity end date and using the weekday formula calculate the week start date for activity start week and end week. Now using the IF & And formula we can get the graphs populated. Colors can be formatted using conditional formatting.
    Attached is the sheet. See if you can help with a code to hide the formula.

    Thanks
    Rajesh

Similar Threads

  1. Activity Based Depreciation If /Then VBA Code
    By mrmmickle1 in forum Excel Help
    Replies: 4
    Last Post: 02-08-2013, 09:09 AM
  2. Replies: 2
    Last Post: 09-08-2012, 10:50 PM
  3. How to Extracting dates and days between 2 dates.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 9
    Last Post: 08-11-2012, 09:11 PM
  4. How to track user activity using a macro?
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-10-2012, 06:50 PM
  5. On Error Statement (Visual Basic)
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 10-12-2011, 09:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •