Diagrams - Informatics and Information Technology


To build charts in Excel, you need a properly prepared table of input data:

• There should not be entirely empty rows and columns within a table;

• the table should be framed with empty cells without data: empty lines from the top and bottom, empty columns on the side;

• the future names of the series and the category signatures should occupy one line from the top and one column on the left, forming the letter T; it is desirable that these cells contain text data.

If the table is made in Word, you need to select it, copy it, go to Excel, put the cursor in the cell that will be the top corner of the table, and give the command Paste.

To create diagrams and graphs in Excel, go to the Insert tab and click the Diagram button to select a view and a subspecies in sketches, for example, a histogram (bars with a height proportional to the values ​​of the categories) and the sample (columns are flat, bulky, cylindrical or conical).

Next, configure the resulting diagram: the Working with Diagrams, Designer, tab, the Select Data button opens the Data Source Selection window.

The Data range line shows the range of cells with data for building a chart-the addresses of the cells in the table, from where the data is taken - from the upper left to the bottom right cell. If the data for the chart is not selected correctly, the window clipping button (in the right corner of the Range row) allows you to temporarily collapse and move the window to select cells on the sheet. To return to this window after selecting a range, click the button again.

On the Working with Diagrams, Layout tab in the Signatures , the Chart Name button allows you to enter a name and choose an option for the location of the name, and Axis name - select the name of the vertical axis (unit of values) and the horizontal axis (category name).

Note: In the 2D chart, the Y - axis of the values, in the 3D chart, in addition to the X and Y axis Z values ​​of data series.

On the side of the diagram are given legend (legend) - what color, what category of data is indicated in the diagram. The Legend button can adjust the position. In simple obvious diagrams, you can turn off the legend.

The diagram is located on the same sheet as the table. An embedded chart is conveniently viewed and printed in the report along with the original data and other information on the sheet. On the Working with Diagrams, Constructor tab, you can select an option on a separate sheet by clicking the Move Chart button.

In the diagram, you can change the required chart element - right-click and select a context command.

The diagram in the Excel worksheet is associated with the data in the table. When displaying a diagram, the Excel workbook stores the table on

Histogram and legend

Fig. 6.10. Histogram and legend

the same or a separate sheet, and a chart embedded in a Word document can be opened with two mouse clicks in the Excel window along with a worksheet (both programs must be installed on the computer). The diagram on the web page of the network can be linked to the file in which the diagram and the table are built.

The diagram can be copied from Excel, go to the Word document at the appropriate place in the text, create a table with one column and two lines, with or without text flow (between paragraphs). Place the cursor in the top cell and insert the chart. Use the lower cell to sign the diagram.

Creating a bar chart. 6.2 you can build a bar graph "average life expectancy in Europe". If the table is executed by a rule with an environment with empty cells, it is sufficient to place the table cursor in any cell of the table. You can force the table or part of the table with the mouse pointer.

Select Diagrams, Histogram, refine the view (histograms): regular (flat - figure 6.10), a three-dimensional or three-dimensional version.

Draw a pie chart. A pie chart is built around a series of table values. 6.2. If corrections are required, click the right Range button and specify the selection of the data range on the sheet. Complete the Chart Name, in the Data Labels check the Share, parameter if you want to display percentages by category or specify Category and Share, to display percent signatures.

Place the chart on a separate sheet or existing one (Figure 6.11).

Pie Chart

Fig. 6.11. Pie chart

thematic pictures

Also We Can Offer!

Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)