How To Change The Domain Of A Graph In Excel

Select the edit button and in the axis label range select the range in the store column.

How to change the domain of a graph in excel. Simply change the c s to d s and the chart will update accordingly. You can also define individual series and the axis by editing them manually after right clicking on the chart and clicking on select data. To change x axis values to store we should follow several steps.

Select data on the chart to change axis values. Pretty straightforward excel function. Left click on the curve in the chart.

This will move the selection and the chart will update. In excel 2013 you can change the scale of axis in a chart with following steps. Open the design tab and press select data.

Launch microsoft excel and open the spreadsheet that contains the graph the values of whose x axis you want to change. If you look at the formula bar you ll see it s referencing column b for the x data and column c for the y data. The last method to edit the series is through the formula bar.

Click on the edit button in the horizontal category axis labels. Change horizontal axis values. If you have two adjacent columns of data x axis data on the left y axis on the right select them and press ok to remake the chart using your x axis range and skip the following step.

Defining series values in a charts and graphs. Click on select data in the resulting context menu. Right clicking on a chart allows you to redefine the data that powers the chart.