They’ve not been updated in years, and Microsoft never talks about them. To see form controls, in the Developer, Controls group, choose Insert.įorm controls might not officially be deprecated, but they’re on their way. In years past, I might have used a form control to control this figure. Now, in this article, I’m going explain how I set up the slicer to change that setting, rather than using a validation list control or a form control. In Interactive Dashboard Magic with Excel Slicers, I explained how to display one of three figures when you enter the values 1, 2, or 3 in a cell. The figure below is using Slicers to control a setting in a workbook, a setting that tells Excel’s Camera tool which of three images to return: a bar chart, a line chart, or a table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |