Hi Phil!
Yes, it is possible to individually color format data labels in Excel. Here's how you can do it:
- Select the chart that contains the data labels you want to format.
- Click on the data labels to select them.
- Right-click on one of the selected data labels and choose "Format Data Labels" from the context menu.
- In the Format Data Labels pane that appears, click on the "Label Options" tab.
- Under "Label Contains," select the options you want to format (e.g. "Value," "Category Name," etc.).
- Under "Label Options," choose "Label Colors" and select the color you want to use for the data labels.
- Click "Close" to apply the formatting changes.
As for your second question, it is possible to add drop lines to a trend line in Excel. Here's how:
- Select the chart that contains the trend line you want to add drop lines to.
- Click on the trend line to select it.
- Right-click on the trend line and choose "Format Trendline" from the context menu.
- In the Format Trendline pane that appears, click on the "Line Style" tab.
- Under "Line," choose "Drop Lines" and adjust the settings as desired (e.g. color, width, etc.).
- Click "Close" to apply the drop lines to the trend line.