Comment Complex Radio Button with airSlate SignNow

Populate esign radio button

today you're gonna learn how you can switch between charts with a radio button in excel and this is an easy trick that you can use when you're setting up interactive dashboards [Music] okay so i have the sales data for different apps by division i want to create radio buttons for the division this way i can control what sales data shows up in the chart now as you can see my source data is unfortunately messy before i create the chart i need to clean up the data that i want in the chart i don't want to change my source i just want to add an in-between table that gets the job done this is going to be my data prep but before i get my hands dirty let's add our radio buttons to do that you need the developer tab so if you don't see this developer tab you can easily add it to your ribbon just right mouse click go to customize the ribbon place a check mark beside developer and then click on ok then you're going to see this and then you can go ahead and insert your radio buttons which you can do from insert controls under form controls here is the radio button or the option button now just click on it and then draw it out here click inside and let's overwrite this so instead of option button one i want to have game here so this is one of the divisions that i have then i want to add two more option buttons one for utility another for productivity so here i can hold down controls i'm going to click on this hold down control and then drag this to the side that's going to create a second copy and now a third copy okay so select the second one you can also right mouse click and edit text if that's easier then let's go with productivity and last one is utility okay so i have these set up and let's just arrange them wherever we want to have them in a report now what happens when i click on one i get this black dot in the middle and notice that it's smart it knows that they belong together i can't select two of these at the same time now the reason it thinks that they belong together is because i don't have them inside a group so whenever i add another option button to this sheet it's automatically going to belong to this set if i want to create different sets of option buttons i need to put them inside a grouping that looks like this so that's a group box if you click it drag it out here and carefully place your option buttons in a group box then they're going to be independent to other option buttons that you might have on that sheet now in this case i don't need this grouping because these...