To show what the reference line represents, select the Show Name and Show Value checkboxes. Maximum: A line that runs through the highest value of the dataĬustom: A line that runs through a value you specify Minimum: A line that runs through the lowest value of the data Median: A line that runs through the middle value of the data
In the Format sidebar, click the Axis tab, then click the Value button near the top of the sidebar.Ĭlick the disclosure arrow next to Reference Lines, then choose any of the following types of reference lines from the pop-up menu:Īverage: A line that runs through the mean value of the data
A chart can have up to five reference lines. Reference lines make a chart easier to interpret 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.
