In some good exercises at the end of the year, the end of the year, ... you may have to draw a chart based on the aggregated data to show the image data for many others to see, QuanTriMang. com instructs you to manipulate charts in MS Word program.
MS Word: In some good exercises at the end of the period, the end of the year, . you may have to draw a chart based on the aggregated data to show the image data for many others to see , QuanTriMang.com instructs you to manipulate some charts in MS Word program:
1- Draw a chart 2- Change the chart type again 3- Edit the content displayed on the chart 4- Rotate & display chart according to 3-D image 5- Change chart format 6. Change the data point format 7. Change chart background color 8- Change the bottom of the chart
1- Draw a chart
1. To draw a chart that requires a data table, you can enter the data into the previous table and select the chart icon; or you can select the chart icon first and then enter the data into the Data Sheet table.
Example chart with the following data table:
Year
Revenue
Cost
Profit before tax
VTC
Profit after tax
2004
100,000
80,000
20,000
5,600
14,400
2005
150,000
150,000
0
0
0
2006
200,000
120,000
80,000
22,400
57,600
2. Select (black out) the data sheet.
3. Click on the icon Picture 1 of Chart in MS Word on the Standard toolbar (Or go to Insert Object . The Object dialog box appears. On the Create New tab, select the Microsoft Excel Chart program)
4. Appears the chart drawing program window and Data Sheet data entry panel allows to import or edit the table data contents. At this time on the data sheet & chart there may be font errors, you can edit them directly in that data sheet.
Picture 2 of Chart in MS Word
5. Double-click on the drafting screen if the chart is complete. At that time, editing the chart almost to edit photos, especially, has a toolbar for editing.
6. Want to edit the content & chart style: Double click on the chart. Or right-click on the chart, select Chart Object Edit:
Picture 3 of Chart in MS Word
2- Change the chart type again
1. You are in the graph editing screen, right-click, select Chart Type .
Picture 4 of Chart in MS Word
2. Display the Chart Type dialog box, select the Standard Types tab.
Picture 5 of Chart in MS Word
- Please select the chart type according to the Chart type list and select the chart image in the Chart sub-type box. - Select the Set as default chart button if you want to let the selected chart type be used for the following chart drawing.
3. You can select the Custom types tab to choose a different type of chart
4. Click the OK button to complete the chart type change
3- Edit the content displayed on the chart
1. You are in the graph editing screen, right-click, select Chart Option .
Picture 6 of Chart in MS Word
=> The Chart Option dialog box appears:
2. Tags Titles: The title on the chart
Picture 7 of Chart in MS Word
- Chart title: Name of the chart - Category (X) axis: Title X axis - Series (Y) axis: Y axis title - Value (Z) axis: Value displayed on Z axis.
3. Axes card: Value displayed by the axis
Picture 8 of Chart in MS Word
þ Category (X) axis: Displays the value of the X axis
ž Automatic: Under automatic mode ž Category: By type ž Time-scale: According to the time axis.
þ Series (Y) axis: Displays the value of the Y axis þ Value (Z) axis: Displays the value of Z axis.
4. Gridlines tab: Change the bottom of the chart.
Picture 9 of Chart in MS Word
5. Legend card: Annotation
Picture 10 of Chart in MS Word
þ Show legend: Show / Hide comments Placement: Placement:
ž Bottom: Under the chart ž Corner: In the corner of the chart ž Top: On the chart ž Right: on the right of the graph ž Left: Left of the chart.
6. Data Labels tab: Displays data and value labels
Picture 11 of Chart in MS Word
- Labe Contains: Labels - Separator: Separator of numerical value.
R Legend key: Show / Hide the legend icon on the data label.
7. Data Table Card: Displays the data table
Picture 12 of Chart in MS Word
R Show data table: Show / Hide data table R Show legend keys: Show / Hide the legend icon in the data table.
4- Rotate & display chart according to 3-D image
1. You are in the graph editing screen, right-click, select 3-D View .
Picture 13 of Chart in MS Word
=> Appear 3-D View dialog box:
Picture 14 of Chart in MS Word
- Elevation: Rotate the chart horizontally. - Rotation: Rotate the chart vertically. - Perspective: Remote perspective. You can use the appropriate chart rotation function buttons.
5- Change chart format
1. You are in the chart editing screen, want to change the font in any area, right-click in that area. Next, choose Format Axis . (Format Legend .)
Picture 15 of Chart in MS Word Right-click the data area on the coordinate axis
Picture 16 of Chart in MS Word Right-click the legend area
=> Appear the Format Axis dialog box
2. Pattern Cards: Line style
Picture 17 of Chart in MS Word
3. Card Scale: Stretch chart
Picture 18 of Chart in MS Word
R Categories in reverse order: Reverse the chart
4. Font Card: Change the font
Picture 19 of Chart in MS Word
5. Number Card: Types of data formats: number, date, currency, percentage, .
Picture 20 of Chart in MS Word
6. Alignment Card: Align
Picture 21 of Chart in MS Word
6. Change the data point format (With the example chart in the lesson, data points are columns).
1. You are in the chart editing screen, want to change the format of any data column, right-click the data column, select Format Data Point .
Picture 22 of Chart in MS Word
=> The Format Data Series dialog box appears
2. Patterns Card: Change the background color and column border data
Picture 23 of Chart in MS Word
You can click on the Fill Effect button . to select the more interesting background colors in a format: dot-dots, use 2 colors, even use images available on your computer to make the column color background material.
3. Card Shape: Shape of data column:
Picture 24 of Chart in MS Word
4. Data Labels tab: Data column label of the chart.
Picture 25 of Chart in MS Word
5. Options Card: Option to be big and small; tilt column data.
Picture 26 of Chart in MS Word
After each change to the data point format, the color points in the legend section will also be changed accordingly.
7. Change the chart bottom format
1. You are in the graph editing screen, right-click on the chart bottom position, select Format walls .
Picture 27 of Chart in MS Word
=> A Format walls dialog box appears
2. Choose color according to your preferences (color should be contrasted with the color of the data column for easy viewing).
Picture 28 of Chart in MS Word
You can click on the Fill Effect button . to select the more interesting background colors in a format: dot-dots, use 2 colors, even use images available on your computer to make the column color background material.
8- Change the bottom of the chart
1. You are in the graph editing screen, right-click on the bottom of the chart, select Format Gridlines .
Picture 29 of Chart in MS Word
=> A Format Gridlines dialog box appears.
2. Card Patterns: Line style
Picture 30 of Chart in MS Word
3. Scale Card: Some modes of data column elasticity.
Picture 31 of Chart in MS Word
These are some of the features that are frequently used when drawing graphs. In addition, when in the graph editing screen, there is also a toolbar to edit. Anyone who needs to know how to draw a chart in MS Excel can use this article as a reference. The above example has the following result of the chart editing process: