It is sometimes not always easy to trace which data point relates to which series in a chart, especially when it comes to a line chart. To overcome this problem, we can dynamically highlight an individual data point. Let’s get started.
Download the workbook to practice.
Select the Developer Tab > Insert > and select the Option Button (Form Control). Click anywhere in the worksheet to insert the button.
Note: if you do not see the Developer Tab, follow the steps below:
To display the DEVELOPER tab, click on the File menu and then select Options from the drop-down menu.
When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button.
Now you should see the DEVELOPER tab in the toolbar at the top of the screen.