Computer Basics -11 || Using Charts in place of Data Tables in Excel.

Charts are the graphical representation of the data. Using Charts in place of Data Tables are more realistic than tables or any other mode of presenting data.

This is a very attractive feature of Excel, which is used by each professional to create their presentations, reports, data collection, etc.

Note: A table should have at least two data columns to generate any type of chart.

Benefits of Charts

Instead of showing data in tables we could use charts. Below are the basic features of Charts:

1. Easy to use and apply charts on any existing data table.
2. Customization of charts is very easy and doesn’t impact the original data.
3. Presenting data in a chart over a table is more powerful. Best way to convey information to the audience with references.
4. One table multiple presentations. It means any number of the chart can be generated using a single data table.
5. Multiple types of charts available like Column, line, pie, bar chart, etc.

Properties of Charts

There are some important information or properties of charts which have been used to convey the information or present the information more accurately. It makes the data more understandable to the audiences.

1. Chart Type: Correct chart type should be used to convey the relevant information.
2. Chart Title: Chart title should be crystal and clear to make understand viewers the objective to chart.
3. Axis values/Data: Data values will appear in horizontal-axis or vertical-axis.
4. Axis Titles: Short description of the data appearing on the axis.
5. Series: Presentation of data on the Chart. We can change the color of each series in the chart.
6. Legends: As mentioned in the above point, we can change the color of each series in the chart. Legends are the color notation and name to identify the individual series.
7. Data Labels: Data label used to show the value of each series on the chart.
8. Select Data: To add/remove values of any row or column from the Chart, without impacting the original table.

Example 1:

Suppose we have below data table which we need to convert into Charts.

Item wise Sales
Item Name	Sales
TV	100
Fridge	59
AC	70
Cooler	200
Fan	60
Microwave	150
Water Pump	10

Creating Column Chart

Customizing a chart using various Properties

To Set Chart Title

To Set Axis Titles

1. Select the Chart.
2. Navigate to Chart tools > Layout
3. Select an option from “Axis Titles” dropdown.
4. Select “Primary Horizontal Axis Title”.
5. Select “Title below Axis”
6. The title will appear below the Horizontal Axis.
7. User can double click on the title text to edit the same.
8. The same way we could set Vertical Axis title also.

To set the color of Series on the Chart

1. Right Click on any bar or series on the chart.
2. Click on Shape Fill Color icon.
3. Select any color.
4. Repeat the above steps for all the bar or series as per requirement.

To set Legends

1. Select the Chart
2. Navigate to Chart tools > Layout
3. Click on any option under “Legend” dropdown.
4. For example, click on “Show Legend at right”
5. Legend will appear on the right side of the chart. Observe that it would contain color notation for each series/bar. Also, horizontal axis text will appearing along with the color to make it more understandable.

To Set Data Labels

1. Select the Chart
2. Navigate to Chart tools > Layout
3. Click on any option under “Data Labels”.
4. For example, Click on “Outside End”.
5. Observe that values of bar/series will appear over each bar.

To modify the range of data using Select Data

1. Select the Chart
2. Navigate to Chart tools > Design
3. Click on Select Data
4. User can modify the range using “Chart data range”
5. Click on OK

Creating a Pie Chart

1. Select the entire data table.
2. Navigate to Insert > Pie in Charts section
3. Click on any type of chart in the menu. (e.g. Pie-first option)
4. The simple chart will appear on the screen.

Note: All the customization process(mentioned under “Creating Column Chart” section) can be applied to any type of chart.

Displaying Data Labels as in % Form

1. Click on Pie Chart
2. Navigate to Chart Tools > Design
3. Select any Layout under “Chart Layouts” section.
4. We could observe that Data Labels will appear along with percentage value rather than normal values(Sales quantities).

Example 2

Consider another example of a data table contains three columns.

Item	Actual Cost ( $ in Thousands)	Profit ( $ in Thousands)
TV	250	50
Fridge	90	20
AC	210	70
Cooler	200	10
Fan	80	7.5
Microwave	150	50
Water Pump	150	80

We could create a chart using the same steps mentioned above.

1. Select the entire data table.
2. Navigate to Insert > Column in Charts section
3. Click on any type of chart in the menu. (e.g. Clustered column-first option)
4. The simple chart will appear on the screen

Note: All the chart can be customized using the steps mentioned in Example 1 section.

Help & Support:

---

Related Links:
Computer Basics -1 || Introduction and Structure of Computer.
Computer Basics -2 || Types of Computers and Usage.
Computer Basics -3 || What are the different types of Software?
Computer Basics -4 || Importance of Operating System(OS).
Computer Basics -5 || Understanding of Number System.
Computer Basics -6 || Understanding MS-DOS Commands.
Computer Basics -7 || Important Features of MS-Word.
Computer Basics -8 || Let’s learn the usage of MS-Excel.
Computer Basics -9 || Understand and Implement Data Validation in Excel.
Computer Basics -10 || How to apply Filter in a data set in Excel?
Computer Basics -11 || Using Charts in place of Data Tables in Excel.
Computer Basics -12 || Advantages of PivotCharts over Simple Charts in Excel.
Computer Basics -13 || Creating pivot charts/tables in Excel.
Abbreviations to Full-Forms in Computer Basics.
TestNG:
TestNG – 1 || Introduction and benefits of TestNG Framework.
TestNG – 2 || Installation process and a sample program of TestNG.
TestNG – 3 || Create and execute multiple Test Cases.
TestNG – 4 || Let’s understand @Test Annotation and attributes.
TestNG – 5 || Understand Assertion in TestNG.
TestNG – 6 || Use of @BeforeMethod and @AfterMethod.
TestNG – 7 || Use of @BeforeClass and @AfterClass.
TestNG – 8 || Creation and execution of Test Suites.
TestNG – 9 || Let’s move deep into the Test Suites.
TestNG – 10 || Use @BeforeTest and @AfterTest Annotations.
TestNG – 11 || Groups attribute with @Test Annotation.
TestNG – 12 || Use of @BeforeGroups & @AfterGroups.
TestNG – 13 || Use of @BeforeSuite & @AfterSuite.
TestNG – 14 || DataProvider annotation & attribute.
TestNG – 15 || DataProvider with parameters.
TestNG – 16 || Access data from Excel sheet using DataProvider.
TestNG – 17 ||  Passing multiple Parameters in testng xml.
TestNG – 18 || Multiple Browser and Parallel Execution in TestNG.
TestNG -19 || Concept of Parallel Execution.
TestNG – 20 || Run TestNG Program using main() method.
Java Basics:
Basic Java – 1 || Understand Java before start learning JAVA.
Basic Java – 2 || Variables and Data Types used in JAVA.
Basic Java – 3 || Understanding Class, Objects, Methods in Java.
Basic Java – 4 || More on methods(Return Type and Parameters)
Basic Java – 5 || Methods- Call by Value and Call by Reference in Java.
Basic Java – 6 || Understanding of Constructor and Destructor in JAVA.
Basic Java – 7 || Static Variables and Methods.
Basic Java – 8 || Lets learn about Arrays in Java.
Basic Java – 9 || Performing multiple operations using Java Operators.
Basic Java – 10 || Conditions (If and Switch) in JAVA.
Basic Java – 11 || for and for-each in Java. (Loops Part-1)
Basic Java – 12 || Alternate looping concepts while and do-while. (Loops Part-2)
Basic Java – 13 || Decimal values v/s Octal base(8) values in JAVA.
Basic Java – 14 || Difference between IndexOf() and lastIndexOf() methods of Strings in JAVA.
Basic Java – 15 || Runtime User Input using Scanner Class (Part-1).
Basic Java – 16 || Runtime User Input using BufferedReader Class (Part-2).
Basic Java – 17 || Runtime User Input using Console Class (Part-3).
Basic Java – 18 || Difference between break and continue keywords.
Basic Java – 19 || Sending Email using Java (Part-1).
Basic Java – 20 || Sending Email with attachment using Java (Part-2).
Java File Handling:
File Handling | Reading data from word document(.doc or .docx) in JAVA.
File Handling | Reading data from Excel files (.xls or .xlsx) using JAVA.
File Handling | Writing data into an Excel(.XLSX or .XLS) File.
File Handling | Implement formatting in Excel using Java.
File Handling | Copy existing data from one workbook to another workbook in Java.
File Handling | Reading data from PDF file using JAVA.
File Handling || Traverse folders and subfolders in Java.
File Handling || Reading and Writing data from a text file.
File Handling || Multiple file creation using template based input data.
Framework || Simple example of Key Driven Framework using excel sheet in Selenium(JAVA).
OOPs Concept:
Java || Abstract class with Constructor.
Java | Object Oriented Programming (OOPs) Concept
Java Question And Answer:
QnA | Difference between Integer and int keywords.
QnA | Can main method be overloaded?
QnA | How do I reverse a String/Sentence in Java?
QnA | Perform Multiplication and Division without * or / or % operators.
QnA | How do I get the default value of data type?
QnA | How to split String if it contains period symbol (.) in between?
Java Programs:
Different ways to Reverse a String in Java.
Copy formatting & style of cells from one sheet to another.
Getting IP address and Hostname using InetAddress Class.
User inputs via Command Prompt using arguments of main() method of a class.
Program for List and ArrayList in Java.
Useful methods and implementation under Scanner Class.
Swapping two variable values without using any third variable.
Difference between int x= 10 and y=010 in Java.
Parameterized Constructors v/s Setter and Getter function in JAVA.
Override a Static Method.



			
			Post Views: 
			1,032
			
 
2115total visits,5visits today