Work with graphs and charts in Excel

The Microsoft Excel Spreadsheet Editor has very extensive capabilities that make it much easier to perform certain tasks, provided that the user has the necessary knowledge and skills to work with the program. In addition to creating tables, Microsoft Excel allows you to perform calculations of varying complexity, as well as build graphs and charts.

This is exactly what we'll talk about in this article. We will try to consider in as much detail as possible all the nuances associated with building charts and graphs in Excel. Let's figure it out. Go!

The editor allows you to visually arrange calculations for presentations.

In general, the construction of graphs is not a difficult task, however, some users are still baffled by the choice of different types of diagrams or there are difficulties with the correct construction of tables with source data.

In total there are two approaches to solving this problem:

  • Constructing scatter plots.
  • Plotting.

The first approach is used when one value defines another. An example is the classic function. The second option is good to use when you need to see the changes in the data series.

We now turn directly to the construction of the schedule. First you need a table with data. Next, select the table and go to the "Insert" tab. In the toolbar you will see a panel in which you need to select the type of chart. Select "Schedule". The program will offer you a choice of several options. Select the desired, based on your goals and objectives. After that, Microsoft Excel will build the desired graph. Please note that cells that contain non-numeric values ​​will be used as a signature. If you want to do without them, then just do not select them, in this case, the points will be numbered in order instead of signatures.

If necessary, you can change the location of the resulting schedule. To do this, right-click and select “Move chart” in the list that appears. In the movement parameters window, you can select “On a separate sheet” or “On an existing sheet”.

In addition, you can make other manipulations: change signatures and components at their discretion. To do this, there are tabs "Designer", "Layout" and "Format". You can change the name of the chart itself, the axes, and also edit the legend in the “Layout” tab in the “Axes” and “Signatures” blocks. Going to the "Format" tab, you can edit the fill, contours and dimensions. In the "Row Changes" window, the data of the series is adjusted. For example, you can set your own arbitrary name for each of the series, or specify the necessary ranges of variables.

Now let's figure out how to build a scatter chart. As mentioned above, this method is suitable for graphing functions. Take the classic function. You will need a table with x and y values, respectively. Then everything is similar to the previous case, only in the toolbar you need to select "Dot" and specify the desired option. After this, the schedule will be constructed according to the established values ​​and parameters. The editing process is the same as in the first case. On the "Designer" tab, you can add a few more columns. For example, except for x and y, add a and b. Now you should use the option "Select data", which allows you to select data from the table.

If you need to build a histogram, then the method is no different from the above. Just select the “Histogram” item in the diagram bar, then you can also edit the resulting histogram in the “Designer” and “Layout” tabs.

These are the features that Microsoft Excel provides for working with graphs. As you can see, there is nothing difficult. The build process takes only a couple of minutes and is done in a few clicks.

Write in the comments if this article helped you and ask questions about the topic.