This setting controls the default for all new charts in all workbooks.
Then Excel will only plot the data you’ve selected.
When you select a chart, you could use arrow keys to select various elements in the chart.
The up and down arrow keys will select groups of elements.
Groups have names like Chart Area, Plot Area, Legend, and so on.
you’re able to see the full list in a drop down on the ribbon.
after you grab a group selected, the left and right arrow keys will select elements in that group.
This is a great way to resize and align and multiple charts.
