Instructions on how to create charts in Excel professional

Instead of complicated tables, you want to rely on existing tables and chart in Excel, so it will be easy to track information and compare data with each other. Excel supports many types of charts from column charts, line charts to area charts, scatter charts, radar charts . you can freely choose the chart type that fits the table. Data need to draw a chart.

Instructions on how to create charts in Excel professional Picture 1

Here are instructions on how to create charts in Excel professionally, invite you to refer.

Draw a chart in Excel

Step 1: Select (black out) the data area to chart including the column headings. On the menu bar you choose Insert , you select the chart type in the Charts or you choose Recommended Charts.

Instructions on how to create charts in Excel professional Picture 2

Step 2 : Here you can choose more chart types in the All Charts tab , with each chart type having 2D or 3D format for you to choose:

Column (bar chart), Line (line chart), Pie (pie chart and annular are cut), Bar (horizontal bar chart), Area (area chart), XY (scatter chart), Stock (stock chart), Surface (face chart), Radar (spider web chart), .

Depending on the purpose of the chart that you select the appropriate chart to draw, after selecting the chart you select OK .

Instructions on how to create charts in Excel professional Picture 3

So you've completed the chart for the selected data range.

Instructions on how to create charts in Excel professional Picture 4

Elements on the chart in Excel

Instructions on how to create charts in Excel professional Picture 5

1. Chart area: area to contain all elements on the chart.
2. Chart title: title of the chart.
3. Plot area: chart area.
4. Legend: annotate the elements in the chart.
5. Data label: data labels for diagram elements.
6. Vertical gridlines: vertical gridlines in a chart.
7. Horizontal gridlines: horizontal gridlines in a chart.
8. Vertical axis title: title for the vertical axis (vertical axis) of a chart.
9. Horizontal axis title: title for the horizontal axis (horizontal axis) of the chart.
10.  Data table: a chart of data that can be used to replace data labels.
11. Horizontal axis: the horizontal axis (horizontal axis) of the chart.
12. Vertical axis: the vertical axis (vertical axis) of a chart.

Edit the chart in Excel

1. Move the chart

Hold down the left mouse button on the chart area and drag to the position you want to move.

Instructions on how to create charts in Excel professional Picture 6

2. Change the chart size

Click on the chart, then position the mouse pointer on the knobs (the knobs at the four corners and between the four sides of the chart), a two-dimensional arrow icon you hold down and customize the appropriate size .

Instructions on how to create charts in Excel professional Picture 7

3. Add a title to the chart

If the chart already has Chart Title, then place your cursor on it and enter the title for the chart, you can edit the font, font size, font style, font color in the Font section of the Home tab .

Instructions on how to create charts in Excel professional Picture 8

If the chart does not have Chart Title, then you select the chart -> Design -> Add Chart Element -> Chart Title -> choose the title position.

Instructions on how to create charts in Excel professional Picture 9

Or you can select the + symbol directly to the right of the chart and tick the Chart Title.

Instructions on how to create charts in Excel professional Picture 10

To choose the position for Chart Title, select the black triangle icon next to Chart Title , then enter the chart name in the Chart Title section on the chart.

Instructions on how to create charts in Excel professional Picture 11

4. Edit the chart axis

You just need to double click on the vertical or horizontal axis of the chart, then Excel will appear on the right for you to edit.

Instructions on how to create charts in Excel professional Picture 12

5. Show / hide some elements on the chart

Click the + symbol to the right of the chart, here you have the components: Axes (information on the vertical and horizontal axis of the chart), Axis Titles (vertical axis title, horizontal axis of the chart) , Data Labels ( grid data labels), Gridlines (vertical and horizontal grid lines on the chart), Lengend (annotates the elements on the chart). If you want to display any components, then you tick the box in front of that component, if you want to hide, then you put a check mark before that component.

Instructions on how to create charts in Excel professional Picture 13

To change the type, change the position for any component, click the black triangle icon next to the name of the component and the option to change the element.

Instructions on how to create charts in Excel professional Picture 14

6. Change the layout for the chart

Select the chart -> Design -> Quick Layout -> choose the layout type for the chart.

Instructions on how to create charts in Excel professional Picture 15

7. Change chart style

In the Design tab, select the chart style in the Chart Styles section , to select more chart styles, select the More icon .

Instructions on how to create charts in Excel professional Picture 16

Here you will have more choice of chart style.

Instructions on how to create charts in Excel professional Picture 17

8. Change colors for the chart

To change the color of the chart you select the chart -> Design -> Change Colors -> select the color set for the chart.

Instructions on how to create charts in Excel professional Picture 18

9. Change the style in the chart

Select shapes in the chart -> Format -> select the available shape in the Shape Styles section , fill the shape color in the Shape Fill section, the shape border in the Shape Outline section, the shape effect in the Shape Effects section .

Instructions on how to create charts in Excel professional Picture 19

10. Change the data in the chart

You select the chart -> Design -> Select Data.

Instructions on how to create charts in Excel professional Picture 20

Appear the Select Data Source you change the data in two parts Legend Entries and Horizontal Axis Labels by selecting Edit and select the data range.

Instructions on how to create charts in Excel professional Picture 21

To reverse the position of rows and columns in the chart, select Switch Row / Column and click OK to close Select Data Source.

Instructions on how to create charts in Excel professional Picture 22

11. Print the chart

If you only want to print the chart, select the chart and press Ctrl + P , if you want to print both the data and the chart, you place the mouse pointer outside the chart and press Ctrl + P . Appears window print you can print preview and customize some print settings.

Instructions on how to create charts in Excel professional Picture 23

12. Delete the chart

Select the chart and press the Delete key .

Instructions on how to create charts in Excel professional Picture 24

Above is a detailed guide on how to create charts in Excel professional, hope the article will help you. Good luck!