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, donut charts, and radar 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. 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. Restore an earlier version of a spreadsheet.Save a large spreadsheet as a package file.Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.

Use a keyboard shortcut to apply a style.Create, rename, or delete paragraph styles.Bold, italic, underline, and strikethrough.Format a spreadsheet for another language.Select text and place the insertion point.Add a legend, gridlines, and other markings.Add column, bar, line, area, pie, donut, and radar charts.Calculate values using data in table cells.Quickly calculate a sum, average, and more.View the source data for a pivot table value.Change how pivot table data is sorted, grouped, and more.Add calculations to summarize group data.Add checkboxes and other controls to cells.Use VoiceOver to create formulas and autofill cells.Intro to images, charts, and other objects.

How to plot a graph in excel mac 2011