ComputersSoftware

How to build a chart in Excel? Step-by-step instruction for beginners

Today, Microsoft Office is one of the most powerful, modern, convenient and multifunctional complexes, which is well-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 simple notes and text documents, as well as powerful databases, adapted to 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 start working in the case of sheet or book activation, highlighting or changing the cell, pressing the corresponding key and M.

One of the most simple and intuitive features of Excel work is the construction of graphic illustrations to the appropriate range of the spreadsheet. How to make a chart in Excel? The most simple and understandable way that both beginners and professionals use is the Chart Wizard. Find this wizard is not difficult: it is located in the standard toolbar and has an icon that shows 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 run the Chart Wizard, it's easy to build a graph of the function in Excel ! First you need to select the type of chart that you need. Telling how to build a chart in Excel, it is important to pay attention that you need to select this type of chart in the Wizard, and then click the "Next" button, proceeding to the next step.

The second step allows you to select the range of cells that will be used when plotting the graph. However, before plotting in Excel, it is important to designate the axes and sign the corresponding line values, which are called Rows in the Chart Wizard. After you have finished entering all the data for the future graph, you must press the "Next" key, once again proceeding to the next step.

The third step in the process of creating a diagram allows you to transform the appearance of the future graphical display of data. How to build a graph in Excel with a legend display, with a grid of values and with a data table? It's very simple: you need to specify all necessary information about the future diagram at this stage, switching between individual tabs.

In the final fourth step, Excel offers to choose where the created diagram will be located: on a separate sheet or on an existing one (not necessarily on where the chart was started). Completion of the diagram is done after pressing the "Finish" key.

In conclusion, we note that the resulting diagram can always be changed by selecting the resulting graph on the sheet and selecting the Chart Wizard. In this case, the parameters that you chose initially when creating a graphical display of data, will be specified in the wizard. You can change them the way you need.

Considering the appearance of the obtained graph, it is worthwhile to pay attention to that you can make all necessary changes to the obtained diagram by selecting the graph twice. At the same time, the "Format of the chart area" window opens, where you can make all necessary changes.

So, it is obvious that the answer to the question "How to build a chart in Excel?" Is simple and understandable to the user with any level of computer literacy. Microsoft Excel is a unique spreadsheet editor that allows even a beginner to use a very powerful data processing tool.

Similar articles

 

 

 

 

Trending Now

 

 

 

 

Newest

Copyright © 2018 en.unansea.com. Theme powered by WordPress.