How to plot in Excel? Step-by-step instructions for beginners

Today, the Microsoft Office suite is one of the most powerful, modern, convenient and multi-functional complexes, which is deservedly popular not only in large enterprises and institutions, but also ideal for home use. Working with various components of this package, you can create both simple notes and text documents, as well as powerful databases adapted for specific tasks and goals.

Microsoft Excel is one of the programs included in the basic office software package and positioning itself as a spreadsheet editor. In fact, Excel is a powerful tool that allows you to work not only with the basic functions included in the package, but with macros - specially programmed algorithms that begin to work if you activate a sheet or workbook, select or change a cell, press the corresponding key and etc.

One of the simplest and most intuitive features of Excel work is the construction of graphic illustrations for the corresponding range of the spreadsheet. How to make a chart in Excel? The simplest and most understandable way that both beginners and professionals use is the Chart Wizard. This wizard is not difficult to find: it is located in the standard toolbar and has an icon that depicts a bar chart. In addition, the Chart Wizard can be found through the "Insert" submenu (Excel, version 2003) by selecting the corresponding icon.

After you start the Chart Wizard, it is not difficult to plot a function in Excel ! First you need to choose the type of chart that you need. When telling how to build a graph in Excel, it is important to pay attention that you need to select this type of diagram in the Wizard, and then press the "Next" key, proceeding to the next step.

The second step allows you to select the range of cells that will be involved in plotting. However, before plotting in Excel, it is important to identify the axes and sign the lines corresponding to the values, which are called Rows in the Chart Wizard. After completing the input of all data about the future chart, you must press the "Next" button, once again proceeding to the next step.

The third step in the process of creating a chart allows you to transform the look of a future graphical display of data. How to build a graph in Excel with a legend, with a grid of values ​​and a data table? Everything is very simple: all the necessary information about the future diagram must be specified at this stage, switching between the individual tabs.

At the final fourth stage, Excel suggests choosing where the created chart will be located: on a separate sheet or on an existing one (not necessarily where the chart was started). Chart completion is completed after you click Finish.

In conclusion, we note that the resulting chart can always be changed by highlighting the resulting chart on the sheet and selecting the Chart Wizard. At the same time, those parameters that you selected initially when creating a graphical display of the data will be specified in the Wizard. You can change them as you need.

Considering the appearance of the resulting graph, it is worth paying attention that you can make all the necessary changes to the resulting diagram by highlighting the graph twice. At the same time, the "Format of the chart area" window opens, where you can make all the necessary changes.

So, obviously, the answer to the question "How to build a graph in Excel?" uncomplicated and understandable to the user with any level of computer literacy. Microsoft Excel is a unique spreadsheet editor that allows even a novice to use a very powerful data processing tool.

Source: https://habr.com/ru/post/K2503/


All Articles