+ Reply to Thread
Results 1 to 4 of 4

Filtering chart using buttons

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Filtering chart using buttons

    Hello,

    I'm trying to filter series on a line chart using option buttons but option buttons only allow me to have one selected at a time. Essentially, i'm trying to make the built in chart filter option more accessible. Spreadsheet attached.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Filtering chart using buttons

    I'm trying to filter series on a line chart using option buttons but option buttons only allow me to have one selected at a time.
    sounds like you don't want to select one option at time ? you want to select one ones go in and out?
    in which case you are after CHECKBOX ?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Filtering chart using buttons

    one way of doing what you asked for using OPTION button

    the group of buttons control are linked to cell A80
    which controls A81 which is now series Name and cells B81:H81 which is now your Y series Data

    Checkbox control would require a different way of thinking
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Filtering chart using buttons

    see attached example using CHECKBOX

    deleted all except the 4 which i have re-mapped

    if you want all of series you will need to map all the series

    it should be easy to follow
    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. USERFORM - Getting PREV and NEXT buttons to work with filtering
    By fatal.lordes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2018, 04:21 AM
  2. Replies: 3
    Last Post: 05-03-2016, 11:43 PM
  3. [SOLVED] Guidance reqd for filtering with nearby macro buttons
    By Tiger20 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 03:28 AM
  4. Filtering Using Toggle Buttons
    By Farmall in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2012, 04:32 PM
  5. Advanced Filtering a table - with cmd buttons?
    By BoAndBug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2010, 10:22 AM
  6. Command buttons for filtering
    By marc5354 in forum Excel General
    Replies: 16
    Last Post: 02-17-2010, 05:15 PM
  7. Radio buttons & filtering data
    By supsup in forum Excel General
    Replies: 3
    Last Post: 12-16-2006, 03:56 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