- #Edit horizontal axis labels excel 2016 using a range how to#
- #Edit horizontal axis labels excel 2016 using a range full#
- #Edit horizontal axis labels excel 2016 using a range series#
Once you choose Select Data, an Edit Series window will open with information on the axis. In the options window, navigate to Select Data to change the label axis data. Right-click the graph to options to format the graph.
Our goal is to replace the X axis with data from Date Column. From the image below, you can see that this graph is based on the index column and the Selected Period column.
But essentially the steps are the same.įollow the visuals instructions below or watch the video:Ĭreate a graph.
Also, you can directly change x values from Select Data Source window. For categorical data, you don’t need to worry about this. However, if you graph is chronological or time series based you need to pick a complementary chronological data. However, you still can by simply clicking Edit Legend Series and choosing X values. The Edit Series window will open up, then you can select a series of data that you would like to change.įor a time series like months, when you click select data you will not have the option to directly edit the x-axis. Right-click the axis you want to change and navigate to Select Data and the Select Data Source window will pop up, click Editģ. Select the Chart that you have created and navigate to the Axis you want to change.Ģ. Be more efficent and accomplish more with Excel Beginner to Advance Course up to 90% discount from this link.ġ. You can also create a new set of data to populate the labels. You will add corresponding data in the same table to create the label. The procedure is a little different from the previous versions of Excel 2016. 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.Often there is a need to change the data labels in your Excel 2016 graph. 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. The chart is not storing any extra data or information about your spreadsheet. Once you experiment with the charts feature of Excel for a little while, you will start to understand exactly how it works. My partially modified chart and data are shown in the image below. 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. You can do this by changing the values in the cells from which the chart is being populated. 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. For example, in the chart image below, the horizontal axis labels are the first names of some fake employees. Once your chart has been generated, the horizontal axis labels will be populated based upon the data in the cells that you selected. You can choose to include the column labels for your data if you want to, but Excel will use them in the chart regardless.Ĭlick 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. 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. 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.
#Edit horizontal axis labels excel 2016 using a range how to#
How to Edit Horizontal Axis Labels in Microsoft Excel 2010 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.
#Edit horizontal axis labels excel 2016 using a range full#
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.