Results 1 to 4 of 4

Thread: Userform To Create Individual Charts Based On Selected Date

  1. #1
    Junior Member
    Join Date
    Nov 2013
    Posts
    10
    Rep Power
    0

    Userform To Create Individual Charts Based On Selected Date

    Hello

    At the moment i do not have experience to write code but have started by forming Userform.Could programmer please add first the dates relevant to cells F5:L5 in userform.I will update date in cell F5 every Monday
    Also i need to be able to select 1 of the teams or 2 reams or all 3 teams and then by selecting the button Create Charts.The charts will then be created in the Charts sheets

    Can this be done

    Regards

    TerryB
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Try this
    Attached Files Attached Files
    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
    Junior Member
    Join Date
    Nov 2013
    Posts
    10
    Rep Power
    0
    Nice work excelfox

    Can the following changes be possible
    1. Can each chart have Team 1 ,Team 2 and Team 3 instead of date
    2. A gap between each chart
    3. Can the charts have a gap between each column bar instead of all columns touching
    4. Can the charts be twice as wide as current size

    Much appreciated

    TerryB
    Attached Files Attached Files

  4. #4
    Junior Member
    Join Date
    Nov 2013
    Posts
    10
    Rep Power
    0
    Bump...thanks

Similar Threads

  1. Replies: 1
    Last Post: 08-20-2013, 04:31 PM
  2. $10 to create pivot charts .
    By bethrah in forum Hire A Developer
    Replies: 1
    Last Post: 08-02-2013, 04:01 PM
  3. Filter Pivot Table Based On Selected Value And Show All Results Though VBA
    By hanishgautam in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 07-09-2013, 07:47 PM
  4. Replies: 3
    Last Post: 05-17-2013, 01:22 PM
  5. Replies: 0
    Last Post: 02-27-2012, 01:07 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
  •