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!
You should read it
- Detailed instructions on how to graph in excel
- How to Make a Line Graph in Microsoft Excel
- How to Make a Bar Graph in Excel
- How to Add a Second Y Axis to a Graph in Microsoft Excel
- How to Import, Graph, and Label Excel Data in MATLAB
- How to graph functions in Excel
- Instructions for searching with Facebook Graph Search
- How to Create a Probability Distribution Graph in Excel
- Graph data structure (Graph)
- How to graph trigonometric functions with Excel
- Draw a bar graph with positive and negative values in Excel
- Facebook gradually improves Graph Search