Elizabeth Ricks shows how to include data labels on a line chart in Excel:
Today’s post is a tactical one for folks creating visuals in Excel: how to embed labels for your data series in your graphs, instead of relying on default Excel legends.
To illustrate, let’s look at an example from storytelling with data: Let’s Practice!. The graph below shows demand and capacity (in project hours) over time.
It is significantly more complicated than you might first think.