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.
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.
sounds like you don't want to select one option at time ? you want to select one ones go in and out?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.
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.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks