Use a Check Box Control to Show or Hide Series in an Excel Chart

preview_player
Показать описание
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍
This video demonstrates how to show or hide series in an Excel chart using the check box control. The check box outputs a TRUE or FALSE result and we can reference this in an IF statement to return the series values or an NA error. NA errors are not displayed on a chart.
------------------------
Рекомендации по теме
Комментарии
Автор

Nice.... and a very fitting contribution from your cat :-)

amontesi
Автор

Is there a way to make the legend labels appear/disappear with the checkboxes as well?

natejewkes