A chart can have up to five reference lines. Reference lines make the chart easier to comprehend at a glance and can help you compare the values in the chart to a benchmark value.Īll chart types can have reference lines except stacked charts, 2-axis charts, 3D charts, pie charts, and donut charts.
You can add reference lines to a chart to mark the average, median, minimum, and maximum values in the chart or another value that you specify.
