How to build a graph in Excel? Step by step instructions for beginners

Today Microsoft Office is one of the most powerful, modern, comfortable and multifunctional complexes, which is 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, and a powerful database tailored to specific goals and objectives.

Microsoft Excel – one of the programs included in the package of basic office programs and positioning themselves as a spreadsheet. In fact, Excel – a powerful tool that allows you to work not only with the basic functions included in the package, but with macros – specially programmed algorithms, which start working if you activate the worksheet or workbook, selection or editing of a cell, pressing the appropriate key, etc.

One of the most simple and intuitive functionality Excel – graphical illustrations of the corresponding range in the spreadsheet. How to make a graph in Excel? The most simple and intuitive method, which is used by both beginners and professionals – the chart Wizard. Find the wizard is easy: it is located in the standard toolbar and have an icon, which depicts a bar chart. In addition, the chart Wizard can be found via the submenu “Insert” (Excel version 2003) by selecting the appropriate icon.

After you started the chart Wizard to graph the function in Excel will not be easy! First you need to select the chart type you need. Telling how to graph in Excel, it is important to note that you must select this type of chart in the Wizard, and then press “Next” by going to the next step.

Recommended

How to get out of "Skype" on the "Android" and not only

How to get out of "Skype" "Android"? This question bothers many users. The thing is that the messenger is not so difficult. But there are features that are only for mobile versions. To log out of Skype in this case more difficult than it seems. But i...

Kingo ROOT: how to use the program to gain administrative rights on Android

The Gadgets on the platform Android regained the lion's share of the market. Developers are continually perfecting the OS, trying to fit the needs of the users, but from year to year admit palpable mistake: forbid the owner to "stuffing" of his gadge...

How to get from Stormwind to Tanaris: practical tips

World of Warcraft is an iconic MMORPG, uniting millions of players around the world. There are many locations and puzzles, secret trails and larger, but rather dangerous paths. Sooner or later, every player chose the side of the Alliance, we have to ...

The Second step allows you to select the range of cells that will be used when plotting. However, before you can build a chart in Excel, it is important to label axes and to sign the relevant values of the lines in the chart Wizard are called Ranks. After entering all the data about the future of the chart, press “Next” once again turning 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 the display of the legend by setting the grid values with data table? It's very simple: all necessary information on the future chart, you need at this stage, switching between individual tabs.

On the fourth and final stage, Excel prompts you to choose where to locate a chart: on a separate sheet or on an existing (not necessarily on where it started the plotting). The end of the plot happens after you press “Ready”.

In conclusion, we note that the obtained graph can be changed by highlighting the resulting chart on the worksheet and selecting chart Wizard. The settings that you selected originally when creating the graphical display of data, will be specified in the Wizard. You can change them as you need.

Considering the appearance of the obtained graphics, it is worth to note that to make all the necessary changes in the resulting graph, two times with the line chart selected. However, SAS will open a window called "Format chart area” where you can make all necessary changes.

So obviously, the answer to the question “How to build a graph in Excel?» simple and intuitive user with any level of computer literacy. Microsoft Excel – a unique spreadsheet that allows even a newbie to use a very powerful data processing tool.