How to use two columns of values as the X axis and Y axis of the graph respectively in excel drawing
Ask online customer service
Scan the code to ask online customer service
In online tutorials, two columns are selected, and the first drawing is automatically used as the XY axis. However, no matter how my excel operates, the two columns are used as the Y axis, and the X axis is numbered, that is, there will be two curves. It's strange. I don't know why.X AxisView All
When inserting a chart in Excel, you can set the two data columns as the X axis and Y axis of the chart.The following steps are for setting using Excel 2007: 1. Open Excel 2007 and import the required data. 2. Select the data column to be set as X axis and Y axis.Click "Insert" on the menu bar, then select "Chart", and then click the arrow icon to enter. 3. In the pop-up dialog box, select the "Scatter Chart" type, and select other styles or customization options as required. 4. Click the OK button to create the chart. Through the above steps, you will be able to successfully create a scatter chart with month as the horizontal axis and temperature as the vertical axis in Excel 2007.The scatter plot will show a curve showing the trend of temperature change. Please note that the specific operation may vary with different versions of Excel, but the basic process is roughly the same.If you have any questions or need further help, please feel free to ask me questions.
Use the following methods: 1. Select the first group of continuous data you want to plot 2. Press Ctrl and select the second group of drawing data area 3. Repeat 2 until all data areas (including identification areas) required for drawing are selected 4. Click Chart Wizard to enter the drawing
In addition, if you make a broken line diagram, the X axis does not represent a numerical value, and it is impossible to use the order, unless you notice that they have adjusted the order on the line. For relevant knowledge about this question, please see the answer to my other question:
You can also use formulas: select the first data column, press F11 to insert an embedded chart, and then find the coordinate axis under the Design or Format tab, where you can set the data series corresponding to each coordinate axis.Enter your second column of expressions to make them switch roles
Another method is to drag data directly into the chart area.First, create a blank chart, place the first column of values on the X axis (default), and place the second column of values on the Y axis.Double click the X-axis or Y-axis title, and change its source to your second column data in the pop-up dialog box
In Excel, select the data column you want to use as the X axis, click the Insert menu, and then select chart types such as line chart or scatter chart.In the chart editor on the right, you will see a series tab. Set the Y axis column as the second data column.Remember to adjust the axis title and label