+ Reply to Thread
Results 1 to 3 of 3

Using Drop Down Boxes to Create Dynamic Line Chart

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    92

    Using Drop Down Boxes to Create Dynamic Line Chart

    I cant figure this out. I need to create a drop down Combo Box to select the Year, then graph the corresponding cells. For example, see the attached, I want the drop down box on "Summary Stats" to graph B1 data, all the dates and corresponding data points, with the option to graph B2 and B3 data (when the user selects from the drop down box) from "Source 2014-2015" data tab.

    Can anyone help?

    Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-14-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    92

    Re: Using Drop Down Boxes to Create Dynamic Line Chart

    Anyone can help??

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Using Drop Down Boxes to Create Dynamic Line Chart

    See whether such method will be good ?
    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. Replies: 1
    Last Post: 01-28-2015, 09:11 PM
  2. Dynamic Drop down Boxes
    By avfcjase88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2014, 08:42 AM
  3. Create dynamic line on chart for current date
    By thassim in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 10-10-2014, 07:21 AM
  4. VBA - Updating Dynamic Line Chart & Inserting Dynamic Formula
    By bruno08102013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2014, 10:10 AM
  5. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  6. [SOLVED] dependent drop down boxes and dynamic ranges
    By philcud in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  7. [SOLVED] Dynamic Drop Down Boxes
    By Scooter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2005, 02:06 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