Page 463 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 2: Create a Combination Chart

Combination of two or more chart types in a single chart is known as a combination chart. To create a combination
chart, follow the steps
Step1: First open the MS-EXCEL and then write your data there in the sheet.

Step 2: Create a basic chart and here we are going to plot a column chart for our dataset.

Step 3: We have created a basic chart and now it’s time for complex graphs to play their role. Click either on the
orange bars or blue bars.

Note: Here, we are going to click on the blue bars which are representing the No of Employees. Go
to the design tab, click on the change chart type.

448

CITS : IT & ITES - Computer Software Application - Exercise 74