In the Labels section, click on Axis Titles.Navigate to the Layout tab in Microsoft Excel’s toolbar.Doing so will cause a group of tabs titled Chart Tools to appear in Excel’s toolbar with the Design, Layout and Format tabs residing within it. Click anywhere on the chart you want to add axis labels to.To add labels to the axes of a chart in Microsoft Excel 2007 or 2010, you need to: Excel also allows users to link the label they create for an axis to be linked to corresponding text in a worksheet’s cells by simply creating a reference to those specific cells. In addition, some charts that have axes (such as radar charts) don’t really have the capability to display axis titles so this feature also doesn’t 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. 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 can’t 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. There are an array of different kinds of charts you can create on Microsoft Excel (from pie charts and doughnut charts to scatter charts of graphs and bar charts). Anyone who knows anything about Microsoft Excel knows that one of the many, many features the premiere spreadsheet program for the Windows Operating System has to offer is the ability to create and have charts in an Excel worksheet.
0 kommentar(er)
