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. Show tick marks: Click the Tick Marks pop-up menu, then choose a location.Įxtend radial lines (for radar charts): Select Extend Radial Lines.
Set the number of major gridlines: In the Axis Scale section, click the arrows to the right of the Major field, or type a value in it.
Set the line color: In either the Major Gridlines section or the Minor Guidelines section, click the color well or color wheel, then choose a color. If you’re working with a radar chart, you can also click the pop-up menu below Radial Lines (in the Category tab) and choose a line type. Set the line type: Click the disclosure arrow next to Major Gridlines or Minor Gridlines (in the Value tab), or Gridlines (in the Category tab), then click the pop-up menu and choose a line type. In the Format sidebar, click the Axis tab, then choose Value (Y) or Category (X) for the axis you want to modify. You can specify whether to show chart gridlines and modify their look.
