How to create charts in excel 2007 is extremely simple!

Excel is a Microsoft Office product, helping users to create tables, calculate, analyze data . In addition, Excel also supports creating charts to convey information and data to users in a way. dynamic and easy to understand. Today, TipsMake will accompany you to create charts in a simple and aesthetic way and quickly.

1. What is the graph in exel

A graph inExcelis one way of presenting dry data intoeasy-to-understand vividimages.The graph is linked to its data in an Excel table, so when you change the data in the spreadsheet, the graph immediately changes accordingly.

1. Open the workbook containing the data to create the chart
2. Select the required data to create graphs such as headings by row, column and data illustration.
3. From the Insert Menu in the Chart box, select the appropriate chart type that you want to use to represent your data.When choosing a style, there will be a drop-down menu showing samples for you to choose

How to create charts in excel 2007 is extremely simple! Picture 1

1. From these templates, you can choose a template by clicking on it

* An example of creating a chart:

How to create charts in excel 2007 is extremely simple! Picture 2

With Excel 2007 you will have more options in using the chart format because with this version Microsoft Office 2007 provides many beautiful and effective chart templates that are also very powerful in displaying and comparing numbers. Whether.

2. Typical types of Excel 2007 charts

1. Column: Bar chart
2. Bar: Bar chart
3. Pie: Pie chart
4. Scatter: XY chart (scatter)
5. Area: Area chart
6. Donut: Donut chart
7. Radar: Radar chart (by ray)
8. Surface: 3-D face chart
9. Bubble: Pie chart
10. Stock: Bar chart
11. Cylinder: 3-D cylindrical chart
12. Cone: 3-D cylindrical pie chart
13. Pyramid: 3-D pyramid chart

3. Work with charts

The job of creating charts is just one of many jobs that work with charts, with Excel 2007 making it easier to edit charts using the specialized Chart Tools.

How to create charts in excel 2007 is extremely simple! Picture 3

a. The main tool works with charts

The Chart Tools menu includes 3 submenu, Design , Layout , and Format which contain almost all the commands that work with the chart. Here we go through the details of these menus.

* Chart Tool / Design : Contains commands that help you design the chart style and format to suit your desired purpose and effect.

How to create charts in excel 2007 is extremely simple! Picture 4

Type: choose a chart type

Data: The choice to work with your data for charting.

Chart Layouts: A form of chart display

Chart styles : Types of chart styles

Location: Move the chart to another location

After you select this item, the Move Chart dialog box will appear as shown below:

How to create charts in excel 2007 is extremely simple! Picture 5

Select the location to export then Click OK.

* Chart Tool / Layout : Provides the detailed components of the selected chart.Users can edit the details of components based on this submenu.

How to create charts in excel 2007 is extremely simple! Picture 6

* Chart Tool / Format: Provides options to edit detailed properties of the chart

Quick learning chart format.

How to create charts in excel 2007 is extremely simple! Picture 7

b. Appointments are subject to change

After creating the chart often the results are not as expected, so we need to adjust a few ineffective factors such as size of the chart, font, size of details on the chart . sometimes We also need to add or remove data.

c. To adjust dimension

When creating the chart, if the elements in the chart are not satisfactory, move it to another in the following way:

1. Select objects to move.
2. LEFT-CLICK on the object and drag it elsewhere, release the mouse button.
3. To adjust the size of the whole chart: Click on the inner background of the chart, move the mouse on the small square buttons on the border of the inner background, when a double-headed arrow appears, left click the mouse to adjust the size ruler appropriate.The size of the wide chart is less than or equal to the size of the external background
4. Move the whole chart: Click on the inner background of the chart to select, left-click on the inner background of the chart again and move elsewhere, the elements located on the chart will move according to the chart.

d. Format the title of the chart

To format the chart title, follow these steps:

1. Double click the title of the chart to change the content of the chart title.

e. Change, edit figures:for some reason you have to adjust the figures of the chart, please follow these steps:

+ Right click on the chart and select Select Data .

How to create charts in excel 2007 is extremely simple! Picture 8

The dialog box appears as shown below:

How to create charts in excel 2007 is extremely simple! Picture 9

+ You can change the data area to draw a chart by entering the address in the Chart data range frame:

+ Reverse the X and Y axes by clicking the command button: Swich row / Column

+ Insert data, click the Add button.

How to create charts in excel 2007 is extremely simple! Picture 10

+ Edit the data, click the Edit button.

How to create charts in excel 2007 is extremely simple! Picture 11

+ Remove the chart, click the Remove button.

After resetting the data, click OK to apply the changes to the chart.

Change chart type : You can change the chart type after you have finished drawing the chart by right-clicking on the chart and selecting Change Chart Type dialog box as shown below:

How to create charts in excel 2007 is extremely simple! Picture 12

You select a chart type in the left pane, then select the chart in the right frame then click OK.

Format Chart Area:Right-click on the chart, and then select Format Chart Area to open this dialog box.

How to create charts in excel 2007 is extremely simple! Picture 13

+ Fill: background color for the chart

+ Border Color: The color for the contour

+ Border Style: Style for the border border

+ Shadow: Options for shadows.

The change options for the chart are shown on the three menu areas you click on the chart in a very detailed and intuitive way.

TipsMake wish you a successful reading!