How to Change Horizontal Axis Labels in Excel 2010

Microsoft Excel 2010 is a very helpful tool for organizing and displaying data. 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. These charts will be automatically generated from the data that you select and will typically display the data in the manner that you desired. However, sometimes Excel will not understand what you are trying to do, and will label your data in a different way than you desired. Fortunately this problem is easy to fix when you learn how to change the horizontal axis labels on your chart.

 

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. 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.

To begin, open your Excel spreadsheet that contains the data that you want to graph, or that contains the graph you want to edit. 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.

Use your mouse to highlight the data that you want to include in the chart. You can choose to include the column labels for your data if you want to, but Excel will use them in the chart regardless.

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.

how to create a chart in excel 2010

 

Once your chart has been generated, the horizontal axis labels will be populated based upon the data in the cells that you selected. For example, in the chart image below, the horizontal axis labels are the first names of some fake employees.

sample excel chart

 

If, for example, I wanted to add some anonymity to the chart, I might choose to relabel these employees with more generic terms, such as “Worker 1″, “Worker 2″, etc. You can do this by changing the values in the cells from which the chart is being populated. If you do not want to change the data in these cells, then you should insert a new column to the right or left of the current column and add the axis labels that you want to use in the new column. My partially modified chart and data are shown in the image below.

how to change horizontal axis labels in excel 2010

 

Once you experiment with the charts feature of Excel for a little while, you will start to understand exactly how it works. The chart is not storing any extra data or information about your spreadsheet. Everything on the chart is populated from your data so, if you want to make changes to the chart, it must be done from your data.

If you want to change other options of the horizontal axis, right-click on one of the axis labels on the chart, then click Format Axis.

Share this...Share on FacebookTweet about this on TwitterShare on Google+Pin on PinterestShare on TumblrShare on RedditEmail this to someone