Charts make your report look much more intuitive and easier to see than a spreadsheet full of numbers. It is flawed if users do not know how to draw charts in Excel. So, today let Thuthuattinhoc.vn introduce to you how to draw charts in Excel.
Types of graphs in statistics
Before drawing a chart, you must choose the right chart type to represent the data your report is about. Here are some common chart types:
- Line graphs show the change of variables over time across data points.
- Bar charts are another suitable format for comparing data sets. There are two types: vertical and horizontal bar charts. Not only for comparison, bar charts also highlight between variables through bars with color and length according to the value of the data.
- Histogram plots illustrate data over a continuum and a specified time period. The Y-axis you can see the value of frequency and the X-axis shows the continuous value of time.
- The pie chart shows the share of each value in the data set. This type of graph is useful in representing the composition of a dataset.
- The point distribution plot shows the connection between points in the data.
How to draw a chart in Excel
Step 1: Open the Excel file containing the data to be charted, select (black out) the data area to be charted. You choose the whole title to make a caption for the map.
Step 2: On card Insert (first)in cell Charts You choose the line chart, column, circle … (2) that you want to draw. Or tap the expand arrow (3) to expand the map settings.
Step 3: When you click on the expanding arrow, Insert Charts appear. At the card Recommended Charts, if you like, then select the charts that Excel suggests for you. If not, you switch to the card All Charts to select the appropriate chart.
Step 5: On the window All Chartsyou choose the chart type (left area (first) consistent with the data criteria as Thuthuattinhoc.vn introduced above, and select the interface of the chart (2) and how to group the data of the chart (3).
Step 6: After selecting the type of chart you want to display and press the . button OK. Results:
The chart appears, you can adjust some more details to make the information more beautiful and clearer:
- Chart Title: chart name.
- Or you can change the interface and color of the chart in the card Design Chart.
- If you want to change the chart type, click the . icon Change Chart Type.
Step 7: If unfortunately your data part contains excess data to display, and now need to delete part of the data.
You can follow these steps:
- On the card of Design Chars (first)you choose Select Data (2).
- Windows Select Data Source appears, If you want to completely delete the redundant data, change the data area in section Chart Data Source (first)and if you just want to hide the display of certain data, then remove the checkmark in the two lower frames (2).
As a result, the data representing the total has disappeared from the map:
Excel application supports you with many line chart styles for you to choose from.
Above, Thuthuattinhoc.vn introduced to readers how to draw charts in Excel. Good luck!