Axis Labels1:59 with Michael Watson
Overview of the Axis Label chart element.
Exactly as they sound access labels or 0:00 text boxes that title or label the different axis of your chart. 0:03 In Excel, when you select your chart, 0:09 a new section will show up in the ribbon called Chart Tools. 0:12 It has the Design and Format tabs. 0:16 In the Design section, 0:21 over on the left, you'll see a section called Add Chart Elements. 0:22 You can add different elements of the chart or 0:27 take out different elements of the chart here. 0:30 Let's add some axis titles and I'm gonna do it to the primary vertical axis. 0:33 You can move the label around. 0:40 Like so, I'm gonna undo that. 0:45 You can make the font larger in the label. 0:49 Similar to the chart title, you can rename it, so this is, Members. 0:55 You can also change the color and background as well, Format axis title. 1:01 I want it to be a solid fill and 1:07 I'll make it yellow cuz I'm feeling kinda weird right now, why not? 1:09 So sometimes labels aren't necessary because 1:16 it's obvious what we're looking at. 1:20 This is more likely to happen on the x axis. 1:22 For example, here it's pretty clear what these mean. 1:25 Let me make it a little bigger for you. 1:28 We're looking at months, but if this was a numerical value, for 1:33 example on a scatter plot, that might not be so clear. 1:37 When I create charts, I often put them into presentations and 1:41 will add the axis labels in the presentation software, 1:45 instead of having them embedded in the chart area in Excel. 1:48 There are many ways to do this. 1:53 You should find out the one that works best for your workflow. 1:55
You need to sign up for Treehouse in order to download course files.Sign up