While I have shown an example of a scatter chart in this tutorial, you can use the same steps to switch axis in case of any chart in Excel. So these are two simple and easy ways to switch the axis in Excel charts. Type in the Chart title, X and Y Axis values, add Gridlines. The following image shows how to create the y-values for this linear equation in Excel, using the range of 1 to 10 for the x-values: Next, highlight the values in the range A2:B11. Also, this way you don’t need to change any data in your sheet. add gridlines, Graph Title, and labels for the x and y axes. Finally, the time to build the bell curve has come: Select any value in the helper table containing the x- and y-axis values (E4:F153).Go to the Insert tab. Switching the axis option in a chart gives you more flexibility for adjusting the chart axis. Step 5: Create a scatter plot with smooth lines. In this case, you can just move Quantity in column B, and Sales in column C. Another window will open where you can exchange the values on both axes. First, right-click on either of the axes in the chart and click ‘Select Data’ from the options. Secondly, once the text is highlighted, you can select a graph. Click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart. Highlights: How to plot a graph in Excel Firstly, select the cells that have the data you want to use in your graph by clicking and dragging across the cells. Offset options include auto, cumulative, incremental, constant. There’s a better way than that where you don’t need to change any values. Select the data you want to plot in the scatter chart. The above method works great when you have already created the chart and you want to swap the axis.īut if you haven’t created the chart already, one way could be to rearrange the data so that Excel picks up the data and plots it on the X and Y axis as per your needs.Įxcel by default sets the first column of the data source on the X-axis, and the second column on the Y-axis. Origin supports offsetting plots in the X and Y directions with no change in data values. Also read: How to Add Secondary Axis in Excel Charts? Rearrange the Data to Specify the Axis
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |