How to make a selection button dynamic chart in Excel

The following detailed procedures to introduce you:

1, open Excel2007, create a table as shown in the following illustration, click the form control, and add an option button.

2, draw the control in cell F2, and modify the name.

3, copy and paste, modify the name in turn, according to the following look.

4, click the Form Control button, select the group box.

5, the first row of the control by grouping together, right click, select Edit Text.

6, right click on any one control, choose to set the control format.

7, in control, check not selected, cell link to G2, OK.

8, click Insert Chart-Other charts, select the second one in the radar chart.

9. After the chart is inserted, click the menu bar--chart tool--layout--axis--Main vertical axis, click Other main vertical axis.

10. In the Format Axis dialog box, click the Axis option, the maximum minimum value, and the major unit selection to select a fixed value, as shown in the following figure.

11, after the determination, we finished the production, check the corresponding space, you can grade, the chart of the polyline also changes.