How does an Excel table draw multiple curves on a graph?

Source: Internet
Author: User

In general, we usually use a chart that inserts a curve directly. But sometimes, when we finish the experiment, we need to make a comparative analysis of the results. Then, you will need to draw multiple curves on a graph to compare the curves. On this, small knitting is also very confused, in order to solve this problem, small knitting specially learned the operation process. Below, the small set will be how to draw multiple curves on a graph of the operation of the process to share to everyone. (Small series to draw 2 curves for example)

1. On the computer desktop, create a new Excel file (the operation process is to right-click, select "New" option in the option, and then select "Excel File", you can successfully create a new Excel file).

2, double-click the new Excel file open, input you need to make a statistical curve of data, remember the x-axis data in the upper, y-axis data in the bottom.

3, then select the desired x-axis range of large data, first draw the curve. Small series of data, the bottom of the data range is large, then first select the bottom of all the data.

4. Then switch the top menu bar to the "Insert" option, click on the small triangle below the scatter chart and select the curve type with smooth lines.

5, the interface will pop up the graph of these data. Then select the data, right-click, and select the "Select Data" option.

6, pop-up as shown in the Small window, click on the "Add" option, appear as follows the selection data box.

7. In the "series name" Select the data name, this figure is "absorbance"; X-axis series values and y-axis series values, select the data you want to add. The setup diagram looks like this.

8, click "OK", the interface will be able to successfully form two curves on a graph. The following figure is the result of the production of the picture.

How does the

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.