How To Manage Chart Axes And Numbering In Excel For Mac


show more Managing chart axes and numbering provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Managing chart axes and numbering

When you summarize data in a chart, Excel adds markers and labels to the chart's horizontal and vertical axes to help viewers interpret the chart's contents. As with other elements of your chart, you can control the appearance of those markers. So, for example, let's take a look at the chart that I have here, and it's a chart that is tracking the visitors that come to my web site on any given month. On the horizontal axis, I have the month, January, February, March and so on, but let's say that I wasn't really concerned about the actual months; instead, I wanted to know about the trend.

If I wanted to do that, I can hide the values on the horizontal axis so that I don't see them. To do that, you click the chart, and then on the Chart Layout contextual tab, in the Axes group, you click the Axes button, point to Horizontal Axis, and then click No Axis. When you do, Excel hides all of the labels from the horizontal axis. If you want to bring it back, you can jus...

Managing chart axes and numbering
Video duration: 2m 51s 6h 32m Beginner

Viewers:

Managing chart axes and numbering provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...