Microsoft Excel Course Section 04 Creating Charts Notes Set 01

Computer Science Study Guide: Microsoft Excel Course Section 04 Creating Charts Notes Set 01

Access comprehensive study materials and useful resources for MS Office using the Microsoft Excel Course Section 04 Creating Charts Notes Set 01. Designed to align with the 2026-27 academic guidelines, these advanced resources help Computer Science students reinforce core concepts beyond standard textbooks.

Download MS Office Study Material PDF

Navigate directly to the advanced Computer Science study materials using the digital viewer below. Each resource pack includes detailed conceptual summaries and solved practice questions, allowing students to instantly reinforce their learning.

Section 4 shows how to create a chart from a Toy Sales worksheet: choosing a chart type and sub-type, the Chart Tools context tabs, applying a layout and a style, resizing and moving the chart, moving it to a chart sheet and changing the chart type.

Section 4: Creating Charts

In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically update.

You select a chart type by choosing an option from the Insert tab's Chart group. After you choose a chart type, such as column, line, or bar, you choose a chart sub-type. For example, after you choose Column Chart, you can choose to have your chart represented as a two-dimensional chart, a three-dimensional chart, a cylinder chart, a cone chart, or a pyramid chart. There are further sub-types within each of these categories. As you roll your mouse pointer over each option, Excel supplies a brief description of each chart sub-type.

4.1 Create a Chart

The chart used in this section is a column chart titled Toy Sales, with the vertical axis labelled Sales, the products Dolls, Trucks and Puzzles on the horizontal axis, and one column for each of Region 1, Region 2 and Region 3. To create it, start by creating the following worksheet exactly as shown.

ABCD
1Toy Sales
3ProductsRegion 1Region 2Region 3
4Dolls247826402388
5Trucks203121732790
6Puzzles191827222795
7Total642775357973

After you have created the worksheet, you are ready to create your chart.

4.2 Exercise 1

Create a Column Chart

1. Select cells A3 to D6. You must select all the cells containing the data you want in your chart. You should also include the data labels.
2. Choose the Insert tab.
3. Click the Column button in the Charts group. A list of column chart sub-types appears.
4. Click the Clustered Column chart sub-type. Excel creates a Clustered Column chart and the Chart Tools context tabs appear.

4.3 Apply a Chart Layout

Context tabs are tabs that only appear when you need them. Called Chart Tools, there are three chart context tabs: Design, Layout, and Format. The tabs become available when you create a new chart or when you click on a chart. You can use these tabs to customize your chart.

4.4 Exercise 2

Apply a Chart Layout

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click the Quick Layout button in the Chart Layout group. A list of chart layouts appears.
4. Click Layout 5. Excel applies the layout to your chart.

4.5 Change the Style of a Chart

A style is a set of formatting options. You can use a style to change the color and format of your chart. Excel 2007 has several predefined styles that you can use. They are numbered from left to right, starting with 1, which is located in the upper-left corner.

4.6 Exercise 3

Change the Style of a Chart

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click the More button in the Chart Styles group. The chart styles appear.
4. Click Style 42. Excel applies the style to your chart.

4.7 Change the Size and Position of a Chart

When you click a chart, handles appear on the right and left sides, the top and bottom, and the corners of the chart. You can drag the handles on the top and bottom of the chart to increase or decrease the height of the chart. You can drag the handles on the left and right sides to increase or decrease the width of the chart. You can drag the handles on the corners to increase or decrease the size of the chart proportionally. You can change the position of a chart by clicking on an unused area of the chart and dragging.

4.8 Exercise 4

Change the Size and Position of a Chart

1. Use the handles to adjust the size of your chart.
2. Click an unused portion of the chart and drag to position the chart beside the data.

4.9 Move a Chart to a Chart Sheet

By default, when you create a chart, Excel embeds the chart in the active worksheet. However, you can move a chart to another worksheet or to a chart sheet. A chart sheet is a sheet dedicated to a particular chart. By default Excel names each chart sheet sequentially, starting with Chart1. You can change the name.

4.10 Exercise 5

Move a Chart to a Chart Sheet

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click the Move Chart button in the Location group. The Move Chart dialog box appears.
4. Click the New Sheet radio button.
5. Type Toy Sales to name the chart sheet. Excel creates a chart sheet named Toy Sales and places your chart on it.

4.11 Change the Chart Type

Any change you can make to a chart that is embedded in a worksheet, you can also make to a chart sheet. For example, you can change the chart type from a column chart to a bar chart.

4.12 Exercise 6

Change the Chart Type

1. Click your chart. The Chart Tools become available.
2. Choose the Design tab.
3. Click Change Chart Type in the Type group. The Chart Type dialog box appears.
4. Click Bar.
5. Click Clustered Horizontal Cylinder.
6. Click OK. Excel changes your chart type.

You have reached the end of Section 4. You can save and close your file.

Free CBSE Study Guides: Computer Science MS Office

Quick Revision Material for MS Office

Review targeted study resources for MS Office tailored for learners. Utilizing these structured notes and quick-revision tools ensures complete alignment with current CBSE evaluation standards.

Expert Notes and Solved Exam Questions

Designed around the official curriculum, these study guides guarantee standard compliance. Reviewing step-by-step solutions clarifies complex sub-topics within MS Office and demystifies standard marking schemes for Computer Science evaluations.

Additional Study Resources for

Wrap up your chapter revision by testing your knowledge against standard objective question formats. Explore our full library of free, up-to-date sample papers and online assessments to secure top grades in your CBSE examinations.

FAQs

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.