![]() ![]() ![]() 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 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 whether tick marks are inside, outside, or centered.Įxtend radial lines (for radar charts): Select Extend Radial Lines. Set the number of gridlines: In the Axis Scale section, click the arrows to the right of the Major or Minor field, or type a value in it. Set the gridline 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 gridline 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 solid, dashed, or dotted line. In the Format sidebar, click the Axis tab, then choose the axis you want to modify (Value or Category). You can specify whether to show chart axis lines and gridlines and modify their look. Evenly spaced gridlines cross the chart and provide a visual reference for large increments in the values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |