Hi, Is it possible to have a check box option to select all on the attached interactive chart? Thanks in advance for your time and guidance.
Hi, Is it possible to have a check box option to select all on the attached interactive chart? Thanks in advance for your time and guidance.
Add another checkbox with the label Include All. Link to a cell and name the cell INCLUDE_ALL.
Then modify your formula on Raw Data and Model Chart
B1: =IF(OR(Car,INCLUDE_ALL),'Raw Data and Model Source'!B1,"")
do similar for all other cells that control series data.
If you wanted the Include All checkbox to actually check all the other boxes you would need to use VBA to set the named ranges to true.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks