Home >Software Tutorial >Computer Software >How to draw a graph in excel using two columns of data as the xy axis respectively. Tutorial on how to make an xy graph using two columns of data in excel.

How to draw a graph in excel using two columns of data as the xy axis respectively. Tutorial on how to make an xy graph using two columns of data in excel.

PHPz
PHPzOriginal
2024-09-12 09:52:24990browse

Excel tables can help us easily complete data entry, so how can Excel draw a graph with two columns of data as the xy axis? Users can directly select two columns of data, and then directly click the insert option under the toolbar to explore. Let this site give users a detailed introduction to the tutorial on how to make an xy chart from two columns of data in excel. Tutorial on how to make an xy graph from two columns of data in excel 1. The user opens the excel software on the computer and comes to the editing page of the table file to select two columns of data.

excel怎么以两列数据分别为xy轴画图 excel将两列数据做xy图的教程

1. Click the Insert option in the menu bar at the top of the page.
  1. will display the relevant tabs, and the user clicks on the Scatter Plot option.
  2. In the drop-down tab that pops up, users can solve the problem by selecting the desired scatter chart style according to their own needs.

    excel怎么以两列数据分别为xy轴画图 excel将两列数据做xy图的教程

    4. After the setting is completed, the user will find on the table editing page that the xy diagram is successfully displayed on the current page, and the effect is as shown in the figure.

    excel怎么以两列数据分别为xy轴画图 excel将两列数据做xy图的教程

The above is the detailed content of How to draw a graph in excel using two columns of data as the xy axis respectively. Tutorial on how to make an xy graph using two columns of data in excel.. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn