Changing Chart Gridlines and Axes

You can change the chart display by showing axis or gridlines with different measurements. An axis is a line bordering the chart plot area used as a reference for measurement. Chart axes are typically x (vertical or value), y (horizontal or category), and z (only for 3-D charts). If axis titles or scales are too long and unreadable, you might want to change the angle to make titles fit better in a small space, or change the interval between tick marks and axis labels to display with a better scale. Tick marks are small lines of measurement similar to divisions on a ruler on an axis. Gridlines are horizontal and vertical lines you can add to help the reader determine data point values in a chart. There are two ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.