Chủ Nhật, Tháng Hai 5, 2023
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
NATuts
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
No Result
View All Result
NATuts
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
No Result
View All Result
NATuts
No Result
View All Result
Home Tech

How to draw a chart in Excel

26 Tháng Ba, 2022
in Tech
0
How to draw a chart in Excel
585
SHARES
3.2k
VIEWS
Share on FacebookShare on Twitter

Các bài viết liên quan:

How to get travel insurance

Guide on how to get travel insurance with 4 options

24 Tháng Một, 2023
Software Asset Management for Websites: How to Keep Your Sites Running Smoothly

Software Asset Management for Websites: How to Keep Your Sites Running Smoothly

8 Tháng Một, 2023
5 Best Software to Stream Games

5 Best Software to Stream Games

2 Tháng Một, 2023
IBM Bridge To Cloud For Power

IBM Bridge To Cloud For Power- Everything You Should Know

2 Tháng Một, 2023
Top 10 CRM Software For Construction 

Top 10 CRM Software For Construction Enterprises All The Time

31 Tháng Mười Hai, 2022
What Is IBM Software

What Is IBM Software? 4 Business Segments at IBM You Should Know

26 Tháng Mười Hai, 2022

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.

How to draw a chart 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.

Highlight the data area to be plotted

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.

Select arrow expand 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.

Switch to the All Charts tab 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).

Choose the chart type, chart interface and data grouping of the chart

Step 6: After selecting the type of chart you want to display and press the . button OK. Results:

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.

Redundant data

You can follow these steps:

  • On the card of Design Chars (first)you choose Select Data (2).

Select Select Data

  • 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).

Choose to delete or hide data

As a result, the data representing the total has disappeared from the map:

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!

Previous Post

Download Ansys Products 2022 – Detailed installation instructions

Next Post

What are e-money institutions and how they are useful

Megusta

Megusta

Related Posts

5 Best Software to Stream Games

5 Best Software to Stream Games

2 Tháng Một, 2023
Top 10 CRM Software For Construction 

Top 10 CRM Software For Construction Enterprises All The Time

31 Tháng Mười Hai, 2022
Instruction how to use OBS streaming software

Features, settings and how to use OBS streaming software through 9 simple steps

25 Tháng Mười Hai, 2022
What is Trans woman?  What is Transgender Women?

What is Trans woman? What is Transgender Women?

23 Tháng Mười Hai, 2022
Christmas gift: Genuine Windows 10 Pro for only $6.63 and Office 2021 for $14.22

Christmas gift: Genuine Windows 10 Pro for only $6.63 and Office 2021 for $14.22

22 Tháng Mười Hai, 2022
How to get 50 free coins of SkyJoy App to redeem

How to get 50 free coins of SkyJoy App to redeem

21 Tháng Mười Hai, 2022
Load More
Next Post
What are e-money institutions and how they are useful

What are e-money institutions and how they are useful

Trả lời Hủy

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Bài viết mới

How to get travel insurance
Đời sống

Guide on how to get travel insurance with 4 options

24 Tháng Một, 2023
Software Asset Management for Websites: How to Keep Your Sites Running Smoothly
Phần mềm

Software Asset Management for Websites: How to Keep Your Sites Running Smoothly

8 Tháng Một, 2023
5 Best Software to Stream Games
Software

5 Best Software to Stream Games

2 Tháng Một, 2023
IBM Bridge To Cloud For Power
Software

IBM Bridge To Cloud For Power- Everything You Should Know

2 Tháng Một, 2023
Top 10 CRM Software For Construction 
Tech

Top 10 CRM Software For Construction Enterprises All The Time

31 Tháng Mười Hai, 2022
What Is IBM Software
Software

What Is IBM Software? 4 Business Segments at IBM You Should Know

26 Tháng Mười Hai, 2022
W3Schools

Ads

Contact: [email protected]

DMCA.com Protection Status

Categories

  • Android
  • Cạm bẫy tâm lí
  • Chưa được phân loại
  • Đồ họa
  • Đời sống
  • Gen Z
  • Health
  • iOS
  • Kĩ năng mềm
  • News
  • Nhà mạng
  • Phần mềm
  • Phần mềm đồ họa
  • Review sách
  • Software
  • Tech
  • Thiết kế ảnh
  • Thiết kế video
  • Thủ thuật
  • Travel
  • Văn hóa Nam Bộ
  • Văn học
  • Window

Browse by Tag

ai là triệu phú android Apple browser Bullet Journal bản thân chai pin Chỉnh ảnh data domain download fshare game game show giả lập màu hosting IKEA ios khuyến mãi kinh doanh kiến thức kiểm tra pin messenger miễn phí mua sắm Máy ảnh mạng network nghệ thuật ngôn ngữ nhà Trần pin laptop quảng cáo tiếng anh trạng thái Trần Thủ Độ tên miền tắt hoạt động từ vựng video viettel window 10 word zalo Đơn giản

Recent News

How to get travel insurance

Guide on how to get travel insurance with 4 options

24 Tháng Một, 2023
Software Asset Management for Websites: How to Keep Your Sites Running Smoothly

Software Asset Management for Websites: How to Keep Your Sites Running Smoothly

8 Tháng Một, 2023

Trang tin nóng hổi - vừa thổi vừa xem

No Result
View All Result
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z

Trang tin nóng hổi - vừa thổi vừa xem