The Reference Line button is used to draw a reference line over the plotted chart. The reference line is not based on the query, and is not created using any formula or calculation; rather, it is a design element used to draw a generic positive trend.
- Click here to learn about analysis tools that can be used for things like clustering, outliers, regression lines, and more.
Access Reference Line
The reference line drop-down is accessed from the Settings tab of the plotted chart's Formatting panel. Open the drop-down to select from 2 reference line types:
The reference line can also be set from the Component ribbon:
From the Reference Line drop-down, you can select from 2 options:
Standard: this is the default reference line. It draws a line from the smallest scale value on the y-axis to the top right corner of the chart.
Zero Based: draws a line from the 0 scale to the top right corner of the chart.
The look of the reference line is affected by the axis position in the chart.
In these examples the following data set was used to plot a scatter chart, with Net Profit on the y-axis and Expenses in the x-axis:
In this example, the chart was assigned an outer axis position and a standard reference line was drawn. The line goes from the intersection of the axis in the bottom left of the chart, to the top right corner of the chart.
Now a zero based reference line is drawn on the same chart. Both axes display a scale value of 0; the reference line is draw from the 0 that deviates farthest from the axes intersection.
For instance, here the axes were switched so that Net Profit is on the x-axis and Expenses on the y-axis. The zero based reference line still starts from the 0 value for Net Profit, starting from the x-axis rather than the y-axis.
Here the chart is assigned a zero axis position with a standard reference line. The reference line begins at the smallest value on the y-axis and ends at the top right corner of the chart,
Here the chart is assigned a zero axis position with a zero based reference line. The reference line extends from the intersection of the zero values; if only one axis has a zero value, the zero based reference line should look the same as the standard reference line.
Center axis position with a standard reference line.
Center axis position with a zero based reference line.