Once your chart has been generated, the horizontal axis labels will be populated based upon the data in the cells that you selected. Click the Insert tab at the top of the window, then click the type of chart that you want to create from the various options in the Charts section of the ribbon. You can choose to include the column labels for your data if you want to, but Excel will use them in the chart regardless. Use your mouse to highlight the data that you want to include in the chart. We will go through the entire chart creation process so, if you already have the chart created, you can skip to the part of the tutorial where we are actually changing the horizontal axis labels on the chart. To begin, open your Excel spreadsheet that contains the data that you want to graph, or that contains the graph you want to edit. You can modify the horizontal axis labels of your chart, or you can change the unit intervals that Excel chose for the graph based upon the data you selected. How to Edit Horizontal Axis Labels in Microsoft Excel 2010 Most of the benefit that comes from using the chart creation tool in Microsoft Excel lies with the one click process of creating the chart, but it is actually a fully-featured utility that you can use to customize the generated chart in a number of different ways. Fortunately this problem is easy to fix when you learn how to change the horizontal axis labels on your chart. However, sometimes Excel will not understand what you are trying to do, and will label your data in a different way than you desired. These charts will be automatically generated from the data that you select and will typically display the data in the manner that you desired. While most users might not take full advantage of the features that the program has to offer, there are some exciting tools, like charts and graphs, that you can quickly create. Microsoft Excel 2010 is a very helpful tool for organizing and displaying data.
Click Add Chart Element > Axis Titles, and then choose an axis title option. Click the chart, and then click the Chart Design tab. This step applies to Word 2016 for Mac only: On the View menu, click Print Layout.
0 kommentar(er)
