Looking back and forth from the data being reported to a data legend makes it difficult to easily identify the data in your charts.
A simple fix for this is:
- Point your cursor at the end of the data series (line on the graph).
- Double click until only the last data point is highlighted.
- Right click and select “Add Data Label.”
- The value of the data point will display and you can edit it to make a label for the line by clicking inside the box, delete the value and type in your description. This does not change the actual value in any way.
By appending the line it makes it much easier for the viewer to see the data being reported. I also will add as much detail as I can to the chart title and color code it (if it makes sense).