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"). After ...

Get Microsoft® Office Excel® 2007 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.