Final answer:
The Data group on the Design tab in Excel allows you to select a different data set for a chart.
Therefore, the correct answer is: option 'Chart'.
Step-by-step explanation:
On the Design tab in Microsoft Excel or other spreadsheet software, the group that allows you to select a different data set for a chart is typically the Data group.
This group contains options to change the data source for the chart, allowing you to edit the range of data the chart is representing or to switch to a completely different set of data.
Get Design Mode in Excel 2010/2013/2016/2019 Ribbon:
- Click the File tab,
- Click the Options at the left to enter into Excel Option window,
- Click the Customize Ribbon at the left,
- At the right, select the Main Tabs from Customize: The Ribbon drop down box,
- Check the Developer item,
By doing so, you can quickly update your chart to reflect new or additional data without having to recreate the chart.