The visual representation of our table can be improved
with the help of charts
In this video we will see different types of charts
and its use to improve the visual representation of our table
we will use this table
Select only the data in column A
Keeping the shift key pressed on the keyboard
Select the data in column C and D
Go to the Insert Tab, In the Charts Group
Select the Column Chart
Select the first Column Chart
This is the basic Column Chart
This is the title of the Column Chart
Which can be edited
We will see how to edit it, later in this video
These axis can also be edited and formatted
We will see how to do it, later in this video
To edit the chart title
Double click inside the text box
This table is all about Wildlife Population
So we have added the title as Wildlife Population
To change the overall layout of this chart
Select the chart
Chart tools is displayed on the top
Under the chart tools are
the chart design and format tab
Under the chart design tab
we have all these options
we will later see their functions
We will see the details about the chart elements later in this video
These are the quick chart layouts
With the help of quick chart layouts
we can change the layout of our charts very easily
These are the preset chart colors
When used the entire layout of the chart will change
The row and column values can be reversed
with each other with the help of switch Row/Column
The selected chart data can be changed
with the help of Select data
Where you can change the data range
Or Row data
Or even Column data
You can change the chart type
without re-selecting the entire data
With change chart type
Change the chart type to any other chart you want
Move the chart form one sheet to the other
With the help of move chart
We will see how to do it later in this video
Next, is the Format Tab
It has all the formatting options like
changing font, style, color, alignment and much more
Take a moment to check of you have understood
If no, you can always pause the video and go back
We will create a line chart for this table
Line charts are used to display trends over time
Select the table
In the Insert Tab, In the Charts Group
Select the Line Chart
Select the first line chart
This is the basic line chart
We want to display the contribution of each animal
to the total in a particular year
Pie chart can be used to display this contribution
Pie Chart always uses one data series
Select only one year data
Go to Insert Tab
In the Chart Group, Select Pie Chart
Select the first Pie Chart
This is the basic Pie Chart
In this table we want to show the largest text labels
we use bar chart
To form a bar chart
Select the entire table
Go to insert tab
In charts group
Select the Column Chart
Select 2-D Bar Chart
This is the basic Bar Chart
An area chart is a line chart
with the area below the lines filled with colors
Use a stacked area chart
to display the contribution of each value to a total over time
To get an Area Chart
Select the table
In Insert Tab
In Charts Group
In Line Chart
Select 2-D Area Chart
This is the basic Area Chart
When the data in the table changes
The area chart shows changes accordingly
Take a moment to check of you have understood
If no, you can always pause the video and go back
To find relation between the three columns
We use the scatter straight line chart
Go to the Insert Tab
In the Charts Group
Select Scatter Chart
Select Scatter Chart with Straight Line
This is a Basic Scatter Chart with Straight Line
In this table to find out if there is a relationship between
salary and car price
We use Scatter Chart with only Marker
To do so, Select the table
Go to Insert Tab
In the Charts Group
Select the Scatter Chart
Select the first chart
Ie. Mark only Chart
This is the basic Mark only Scatter Chart
We will add a trend line to see how the trend is moving
To do so, under the Chart Tools Design Tab
Go to, Add Chart Element dropdown
Select on Linear Trendline
To create a data series chart
with row and column of numbers
Select the data in the table
Select the basic column chart
We get a basic data series chart
Take a moment to check of you have understood
If no, you can always pause the video and go back
To change the data source for the chart
Under design tab in the chart tools
Select on Select Data
In the Select Data Source dialog box
Select on the switch Row/Column
This is the updated table
After we have switched the data
A new row is added to the table
Need to add it to the chart
To add this row to the chart
In the Select Data Source dialog box
Under the Legend Entries Series
Select add button
Select only on the series Ie. Year
Under the Horizontal Category Axis Labels
Select the Edit button
Select the range
You can see the new range is added to the chart
Next, we will modify the chart axis
To do so, under the Design Tab, in Chart Tools
Select Add Chart Element
Under Axis Dropdown
Select More Axis Option
Select Text Axis
You can see that the axis is updated
To enter the axis title
Click on this plus sign
Select on Primary Horizontal and Primary Vertical Axis
The Axis are added
The axis title too can be edited
as you edited to chart title by double clicking on them
Next, we will see how to change the Axis Values
To do so, under the More Axis Options
in the Add Chart Element
Go to Format Axis
Maximum bound value on the axis is 8000
Major units on the axis are 1000 apart
Change the Maximum bound value on the axis to 10000
Change the Major units on the axis to 2000
You can see the change on the axis accordingly
Next, we want to shift the chart from sheet1 to sheet2
To do so, under the Design Tab, in the Chart Tools
Select on Move Chart
You can either create a new sheet here and give a name
Or add to the sheet2 from the dropdown
You can see, the chart is moved from sheet1 to sheet2
To check how the trend is moving in this line chart
Under the Design Tab, in the Chart Tools
Select on Add Chart Element
Under Trendline, Select Linear
This shows trend in this Line Chart
Take a moment to check of you have understood
If no, you can always pause and go back
There might be variations at each point in this Line Chart
This shows the trend in this Line Chart
Variation in this line chart is also know as error bars
To display these error bars
Under Error Bars
Select More Error Bar Option
Select Vertical Error Bar Direction on Both
Select Cap in End Style
These are the bars showing trend at each point
Take a moment to check of you have understood
If no, you can always pause the video and go back
To show variation in data in a simple table as this
We use Sparkline Chart
To do so, select the table
In the Insert Tab, Under Sparklines Group, Select line
This is the selected data range
In the Location Range
Select the location where you want the chart to be displayed
The Sparkline Charts can also be changed
To do so, select the charts
You can see the Sparkline Tools are displayed
Select on the Column Sparkline Chart
The updated Sparkline Chart is displayed
You can see, this chart has two types of data
Ie. No. of days and profit
It can be displayed using two types of chart in one chart
This is called Combination Chart
To get this, go to the Insert Tab
In the Charts Group, Select the Combo Charts
You can see this displays two types of chart
One is the line chart and the other is the  bar chart
Take a moment to check of you have understood
If no, you can always pause the video and go back
We need to create chart and table
but on two different excel workbooks
Workbook name here is charts
We will go to the File Tab and
Select a Blank Workbook
A New Workbook is added
In the New Workbook
Go to the Insert Tab
In Charts Group, select Column Chart
We get a blank chart
Data needs to be added from a different workbook
If you remember the name it is Charts
In the Chart Tools
Under Design
Select on Select Data
In the chart data range
We will write the formula
=[charts.xlsx]Sheet1!$A$1:$D$7
It means,
The data range is in workbook charts.xlsx
In sheet1
The range is from A1 to D7
This is our chart
The table and chart are on different workbooks
Take a moment to check of you have understood
If no, you can always pause the video and go back
If you liked this video hit the like button
Subscribe to my channel
Click on the bell icon to get reminders of my new videos
See you all next time
