Page 282 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

ADVANCE CHART & GRAPH

The excel charts and graphs are the tools used to visualise the data by representing their values. Now, let’s
discuss the advanced charts and its usage in excel.
What is an advanced chart in Excel ?
Advanced charts are the charts that are beyond the basic charts in excel. If the user has more than one set of data
and if the user wants to compare the data values on the same chart, then the advanced charts come in handy.
The user can create the basic chart for one set of data and then they can add more datasets to that chart. The
user can also format the charts, etc.
The importance of advanced charts in Excel
1 Advanced charts provide more consolidated information in a single chart. It paves way for the user to compare
more than one data set and it helps alot to draw decisions.

2 Advanced charts allow the user to customize the way it appears.
How to Create an Advance Chart in Excel:
In this example, we will create a column chart and format its various chart elements. We will use random sales
data for different courses for this.
Step 1: Create a Dataset in a workbook
In this step, we will be creating the dataset using the following random sales data for different courses.

Step 2: Insert Chart

269

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77