Adding reference lines

There are many use cases where reference lines are used. In our use case, we will continue with the computed sort to see the average profit point for products with a negative profit.

Reference line instructions

In this section, you will create a reference line to identify the average negative profit for the chart:

1. To begin, select the Analytics section next to the Data section, as seen in Figure 8.13:

Figure 8.13 – Analytics pane

2. On the Analytics pane, at the bottom, you will find the Reference Line section in the Custom section. From here, drag Reference Line to the chart. Once done, a new dialog box will appear.
3. In the dialog box, verify that the Entire Table option is selected.
4. Verify that SUM(Profit) and Average are selected in the Value section.
5. Under Label, select Value from the drop-down menu.
6. Select the thick dotted line in the Formatting section. See Figure 8.14 to verify the...