+ Reply to Thread
Results 1 to 3 of 3

VBA - Create Charts using drop down controls

  1. #1
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    VBA - Create Charts using drop down controls

    Running out of time and need some help on a quick VBA Chart-creation macro.

    Data sheet holds the raw data.

    Parameters sheet holds the drop downs for CHOICEs and OPTION

    Charts is currently showing a sample chart I'd like to create with VBA based on the parameters chosen.

    I'd like the chart to actually appear on the PARAMETERS sheet below the "button" when clicked.


    From here, I'll use the second button to create a whole series of charts on the CHARTS sheet using the two CHOICEs and all the "yes" rows (green section of Data table). Harder section...
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: VBA - Create Charts using drop down controls

    Hi,

    I haven't done all the formatting for the chart but here is some basic code to create the chart
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: VBA - Create Charts using drop down controls

    That's very helpful. Thanks so much!

+ 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. Replies: 0
    Last Post: 10-12-2015, 03:25 AM
  2. [SOLVED] Drop Down Menu that Controls CF for Range of Cells
    By dompoma in forum Excel General
    Replies: 3
    Last Post: 04-21-2013, 07:07 PM
  3. Create mutiple combo box form controls using Macro
    By booo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2010, 07:51 PM
  4. How to reset all controls (Drop Down list on a sheet)
    By tariq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2007, 08:06 AM
  5. Create a collection of controls
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-02-2005, 06:20 PM
  6. [SOLVED] Create a collection of controls
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-02-2005, 06:17 PM
  7. Replies: 0
    Last Post: 01-19-2005, 06:34 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