+ Reply to Thread
Results 1 to 1 of 1

VBA code for insert two Chart in Form excel

  1. #1
    Registered User
    Join Date
    11-16-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    51

    VBA code for insert two Chart in Form excel

    In the DATA sheet, the data related to people's rates is stored.

    In the Form sheet, I designed a form. My goal is:

    1- The list of people's names (without repetition) should be displayed in the combobox list (with name cmbName) so that if a record is manually added to the DATA sheet, corresponding name (if new) will be added in the list.

    2- In Case 1, suppose the year 2002 enters. For example, by selecting Amey and click Plot 1, the Average Rate of each month (in that year. Of course, it may not have a score in some months) will be displayed on the front of the form in a bar chart.

    3- In Case 2, suppose (month) from = 3 and (month) to = 7. By clicking Plot 2, draw a bar chart related to the Average Rate of all people from all days in between those two months.

    4- If press Plot 1 or Plot 2 button, the previous chart will be cleared and the new chart will replace it.
    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] VBA code to change a chart based on a selection from a listbox on a form
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2016, 03:07 PM
  2. HTML code link to a chart - how to insert in excel?
    By umbata in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2013, 12:42 PM
  3. VBA Code to insert dynamic data from sperate workbook to chart
    By Policeme21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2012, 04:33 PM
  4. VBA code to insert data from form
    By edwedw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2010, 08:48 PM
  5. [SOLVED] Excel Insert Function form
    By Santa-D in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2006, 01:30 PM
  6. HOW ?Excel chart auto insert /populate a code based on date
    By MikeR-Oz in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 12-22-2005, 08:20 AM
  7. How to insert OLE chart into a user form?
    By thesaint in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2005, 05:26 AM

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