• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to choose appropriate visual images for Excel data

0 Comments

How to choose appropriate visual images for Excel data. Excel is an indispensable tool for “business people” used to enter, manipulate, and analyze data. In particular, it is considered one of the best tools for creating report charts.
However, with the variety of chart types in Excel such as pie, column, table, waterfall, scatter, etc., users are often unsure which type to use to present their data. Therefore, in this article, let’s explore with UniTrain how to use different charts for each case.

Trends over time in Excel

For data sets containing time and numerical values (as shown below), users often want to track trends in a specific quantity over time, such as sales revenue over a year.

How to choose appropriate visual images for Excel data

How to choose appropriate visual images for Excel data

To find the charts that Excel suggests for this type of data, follow these steps:
Step 1: Insert the data into an Excel worksheet.
Step 2: Select the data > click Insert on the toolbar > Recommended Charts.

How to choose appropriate visual images for Excel data

How to choose appropriate visual images for Excel data

For this data set, Excel typically suggests line, pie, and area charts.

How to choose appropriate visual images for Excel data

How to choose appropriate visual images for Excel data

In general, if you want to display trends over time, use a line chart.

How to choose appropriate visual images for Excel data

How to choose appropriate visual images for Excel data

Trends over time in multiple data sets visual images

For data sets containing time and other numerical data (as shown below), users tend to track changes in quantity over time (e.g., heart rate, blood pressure, etc. within an hour).

visual images 5For this type of data set, Excel suggests many different options, including bubble charts, stacked bar charts, and stacked area charts.

visual images 6Comparing categories on data

For a dataset consisting of categories and numbers (as shown below), users tend to evaluate the degree of comparison between different categories for a certain data point (e.g., voting results of different candidates).

visual images 7For this dataset, bar charts, pie charts, and histograms are appropriate choices for visualizing data.

visual images 8
In general, if users need to compare categories, they should use bar charts because this type of chart will help users easily compare data.

visual images 9Although bar charts may also be suitable for this dataset, the best approach is to use bar charts if the X-axis represents time horizontally. This is because readers are accustomed to consistent representation of time horizontally from left to right and representation of categories vertically from top to bottom. As a result, users can absorb visual images faster and more easily.

Comparing categories for components of the whole

For a dataset consisting of categories and percentage proportions (as shown below), users tend to evaluate the degree of comparison between different categories for a certain index in a larger part of the whole (e.g., percentage of people who agree/disagree in a survey).

visual images 10
For this dataset, Excel will suggest using bar charts, pie charts, and histograms.

visual images 11
In summary, Excel has many different datasets and types of charts. In this article, Buffcom suggests some of the most commonly used chart types for work:
1. If you need to show trends over time (for one or more indicators), use line charts.
2. If you need to compare categories (on a data point or for parts of the whole), use bar charts.

 

Rate this post
38
295 Views
How to use the SUMPRODUCT function in Excel with an examplePrevHow to use the SUMPRODUCT function in Excel with an exampleMarch 27, 2023
Excel tips: Using INDEX & MATCH instead of VLOOKUPMarch 28, 2023Excel tips: Using INDEX & MATCH instead of VLOOKUPNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.71 out of 5
    $99.00
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Office 2019 Professional Plus Key Global Bind to your Microsoft Account Office 2019 Professional Plus Key Global Bind to your Microsoft Account
    Rated 4.97 out of 5
    $49.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Windows Server2008 R2 Remote Desktop Services user connections (20)cal Windows Server2008 R2 Remote Desktop Services user connections (20)cal $29.00
  • Kaspersky Premium - 1 Device 1 Year - GLOBAL Kaspersky Premium - 1 Device 1 Year - GLOBAL $37.00
  • Microsoft Office Professional Plus 2010 retail Microsoft Office Professional Plus 2010 retail CD Key Global
    Rated 4.90 out of 5
    $11.00
  • 5 Key Windows 10 Pro Key Global - Combo 5 KEY 5 Key Windows 10 Pro Key Global - Combo 5 KEY
    Rated 4.81 out of 5
    $25.00
  • SQL Server 2014 Standard SQL Server 2014 Standard $20.00
  • Windows Server 2008 R2 Standard Windows Server 2008 R2 Standard $10.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.