Third, they’re not as professional-looking.Īnd fourth, you can’t set up two validation list dropdown list boxes to control the same cell. Second, validation lists require more clicking than Slicers. First, I recently discovered a bug in Excel 365 that makes a validation list difficult to use when a Camera is on the same sheet as the validation dropdown list box. The validation list has at least four problems. Then, in this example, you’d set up a MATCH formula in your FigNum cell to return 1, 2, or 3-depending on which of the items you chose in your validation list. When you choose OK, your active cell will contain a dropdown list box with the choices in your list. Next, in the dialog, you choose Settings, Allow: List, and then you specify that three-cell list as the Source. Then you choose Data, Data Tools, Data Validation, Data Validation to launch the Data Validation dialog. You select a cell where you want the dropdown list box to reside. When you set up a validation list, you first set up the list of choices you want to offer your user.įor example, you could set up a list with Bar Chart, Line Chart, and Table in three adjacent cells. On the other hand, the validation list control is used widely. 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 |