They’re represented as small marks, the length of which indicates the amount of uncertainty associated with a given data series (the data’s variability). To remove a reference line, click the line to select it, then press Delete on your keyboard.Įrror bars give you a general impression of your data’s accuracy. To change the settings for a reference line, click the line, then use the controls in the Reference Line tab in the sidebar on the right. To show what the reference line represents, select the Show Name and Show Value tick boxes. Maximum: A line that runs through the highest value of the dataĬustom: A line that runs through the 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 graph can have up to five reference lines. Reference lines make the graph easier to comprehend at a glance and can help you compare the values in the graph to a benchmark value.Īll chart types can have reference lines except stacked charts, 2-axis charts, 3D charts, pie charts, donut charts and radar charts. You can add reference lines to a graph to mark the average, median, minimum and maximum values in the graph or another value that you specify.
0 kommentar(er)
