- #Scale xaxis in excel scatter chart excel 2016 how to#
- #Scale xaxis in excel scatter chart excel 2016 update#
- #Scale xaxis in excel scatter chart excel 2016 series#
Once, you add the new data and click OK, you will be able to see the update labels reflecting the new data. If you have chronological data, you can directly access the labels. Our goal is to change the x-axis so that you can delete the x values and replace them with the new values.
#Scale xaxis in excel scatter chart excel 2016 series#
Once you choose Select Data, an Edit Series window will open with information on the axis. For charts where you want to specify an X-axis range of numbers, you first need to switch to a scatter chart and then select the range. 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. If I select just 1 set of values (1 column of X. Select the Series, Edit, apply X & Y values to suit. Then create your Scatter chart from the Insert/Charts menu.
Also, you can directly change x values from Select Data Source window. If you're doing all this manually, select the two XY columns to include an empty cell above the X values and a Series name in the cell above the Y values. 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. For example, if you select a data range to plot, Excel will. Frequently those improvements come in the form of semi-automated tasks - common actions that Excel will do with limited intervention. With each new version of Excel, the capabilities of the program grow.
#Scale xaxis in excel scatter chart excel 2016 how to#
Right-click the axis you want to change and navigate to Select Data and the Select Data Source window will pop up, click Editģ. How to Change the Intervals on an X-Axis in Excel. 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.ġ.
Click on the Line Chart button in the Charts group and then select a chart from the. Select the Insert tab in the toolbar at the top of the screen. In this example, we have selected the range A1:D7. You can also create a new set of data to populate the labels. This allows you to choose the range of the x-axis (minimum and maximum values) and the steps between major and. To create a line chart in Excel 2016, you will need to do the following steps: Highlight the data that you would like to use for the line chart. 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. Often there is a need to change the data labels in your Excel 2016 graph.