![]() ![]() If you would like to label the primary vertical axis (primary y axis) of the chart, click on Primary Vertical Axis Title and then click on the option that you want. ![]() If the chart has a secondary horizontal axis (secondary x axis) that you would like to label, you can click on Secondary Horizontal Axis Title and then click on the option that you want. If you would like to label the primary horizontal axis (primary x axis) of the chart, click on Primary Horizontal Axis Title and then click on the option that you want. ![]() To add axis labels in Microsoft Excel 20 To add labels to the axes of a chart in Microsoft Excel 2007 or 2010, you need to: Click anywhere on the chart you want to add axis labels to.ĭoing so will cause a group of tabs titled Chart Tools to appear in Excels toolbar with the Design, Layout and Format tabs residing within it. However, it should be noted that adding labels to the axes of charts works a bit differently in Microsoft Excel 20 than it did in Microsoft Excel 20. In addition, some charts that have axes (such as radar charts) dont really have the capability to display axis titles so this feature also doesnt apply to them.Īxis labels are also available for all of the axes a chart has, which means that you can even have a label for the depth axis in 3D charts and and labels for the secondary horizontal and secondary vertical axes for charts that have them.Įxcel also allows users to link the label they create for an axis to be linked to corresponding text in a worksheets cells by simply creating a reference to those specific cells.Īdding labels to the axes of a chart is a pretty simple and straightforward process regardless of what version of Microsoft Excel you are using. Obviously, this feature is only available for charts that actually have axes in the first place, meaning that charts such as pie charts and doughnut charts cant really have axis labels. To make a chart easier to read and understand, Microsoft Excel allows users to add titles to the axes of the chart. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |