Instructions on how to graph in Excel

Excel helps you to process and calculate data effectively, Excel supports you to graph quickly.

Instructions on how to graph in Excel Picture 1

If you do not know how to graph in Excel, you follow the article below for details on how to graph in Excel.

For example, we have the following data table:

Instructions on how to graph in Excel Picture 2

HOW TO DRAW AROUND IN EXCEL

Step 1: Select the data area to graph, you need to select the label of the data columns.

Instructions on how to graph in Excel Picture 3

Step 2: Next, select Insert , in the Charts section, select the type of graph you want to draw.

Instructions on how to graph in Excel Picture 4

Step 3: At this time, the Excel interface will appear as your selected graph. You can change the layout of the elements on the graph just by selecting the graph, on the Ribbon appears Design tab and Format tab of Chart Tools , select Design -> Quick Layout -> select suitable layout type.

Instructions on how to graph in Excel Picture 5

Step 4: You can also change the way of displaying - reversing row and column data in the graph by selecting the graph -> Design -> Switch Row / Column .

Instructions on how to graph in Excel Picture 6

Step 5: If the chart type you choose does not match the data in the data sheet, you can choose another chart type by: selecting graph -> Design -> Change Chart Type .

Instructions on how to graph in Excel Picture 7

In the Change Chart Type dialog box, select another graph type in the All Charts tab and then click OK to change.

Instructions on how to graph in Excel Picture 8

Step 6: Also in the Design tab you can change the colors for the graph in the Chart Styles section .

Instructions on how to graph in Excel Picture 9

THE MANUFACTURING WITH GRAPHICS IN EXCEL

Move graph

Click to select the area of ​​the chart ( Chart Area ), this time the mouse pointer has 4-way arrow icon as shown below. Then hold down the left mouse button and move the graph to where you want to move and release the left mouse button.

Instructions on how to graph in Excel Picture 10

Change the graph size

You click to select the graph area, between the four sides and four corners of the graph area with knobs. You just need to move the mouse cursor to the hold button, then the mouse pointer will turn into a two-way arrow, you hold down the left mouse button and drag outside or inward to zoom in or out the graph.

Instructions on how to graph in Excel Picture 11

Copy the graph

You need to select the graph and press Ctrl + C to copy the graph, then select the mouse in any cell you want to copy the graph and press Ctrl + V to paste the graph.

Instructions on how to graph in Excel Picture 12

Delete the graph

Select the graph area and press the Delete key on the keyboard to delete the selected graph.

Print the graph

- You can print graphs like other parts of Excel, choose Print Preview before printing to make sure the position of the graph does not cover other Excel content.

- If you only want to print the graph separately, then you select the graph and choose File -> Print to print.

Instructions on how to graph in Excel Picture 13

Thus, the article has detailed instructions for you to graph in Excel. Hope the article will help you. Good luck!