Adding Footnotes or Comments to Data Points in Excel Charts
1. Select the data point in the chart.
- Right-click on the data point and select "Add Data Label".
- Click on the label to select it.
- Right-click on the label and select "Format Data Label".
- Check the box next to "Value From Cells".
- Click on the "Select Range" button and select the cell that contains the text.
- Click "OK" to close the "Format Data Labels" pane.
If you want to add your own text that is not in the data table, you can add a new data series to the chart:
1. Select the chart.
2. Click on the "Chart Design" tab.
3. Click on the "Select Data" button.
4. Click on the "Add" button under "Legend Entries (Series)".
5. Enter a name for the new series in the "Series Name" field.
6. In the "Series Values" field, enter the value that corresponds to the data point.
7. Click "OK" to close the "Edit Series" dialog box.
8. The new series will appear in the "Select Data Source" dialog box. Click "OK" to close the dialog box.
9. Right-click on the new series in the chart and select "Add Data Labels".
10. Click on the label to select it.
11. Right-click on the label and select "Format Data Label".
12. Check the box next to "Value".
13. Enter the text you want to use as the footnote or comment in the "Value" field.
14. Click "OK" to close the "Format Data Labels" pane.