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
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).
Fig. 6.11. Pie chart
Also We Can Offer!
- Argumentative essay
- Best college essays
- Buy custom essays online
- Buy essay online
- Cheap essay
- Cheap essay writing service
- Cheap writing service
- College essay
- College essay introduction
- College essay writing service
- Compare and contrast essay
- Custom essay
- Custom essay writing service
- Custom essays writing services
- Death penalty essay
- Do my essay
- Essay about love
- Essay about yourself
- Essay help
- Essay writing help
- Essay writing service reviews
- Essays online
- Fast food essay
- George orwell essays
- Human rights essay
- Narrative essay
- Pay to write essay
- Personal essay for college
- Personal narrative essay
- Persuasive writing
- Write my essay
- Write my essay for me cheap
- Writing a scholarship essay