Hi R,
Yes, it is possible to select all data points or data labels in a graph at once in Excel. Here's how you can do it:
- Click on the chart to select it.
- Click on the "Chart Elements" button (the plus sign icon) that appears next to the chart.
- Check the box next to "Data Labels" or "Data Points" (depending on what you want to select).
- All the data labels or data points in the chart will now be selected.
- You can now format them all at once by using the formatting options in the "Format" tab that appears in the ribbon.