Manipulating Axes

If you’re not happy with the axes Excel gives you, or if you just want to explore your options, select the chart, click the Layout tab under Chart Tools, and then click Axes in the Axes group. Excel then asks you to specify which axis you want to modify (the number of choices varies by chart type). If you’re a veteran of earlier versions, you’ll notice that, in this context at least, axes are no longer called category and value. Instead, Excel uses the more commonplace descriptions horizontal and vertical. You’ll still see axes described as primary when there are no secondary axes, but that’s because it’s possible for a two-axis chart to acquire one or more additional axes. (See Assigning a Series to a Secondary Axis on page ...

Get Microsoft® Excel® 2010 Inside Out 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.