Todays ms excel lesson 21-11-2011 (charting)

 

A simple chart can say more than a sheet full of numbers. As you’ll see, creating Excel charts is very easy. This chapter teaches you how to create a chart, how to switch rows to columns, how to add a chart title, how to change the legend position, how to change to a different type of chart, and how to create a pie chart.

 

Create a Chart

To create a chart, open the accompanied Excel file, and execute the following steps.

1. Select the data range you want to include in the chart. In this example, select the range with address A1:E4.

Select the Data Range

Note: include the headers when selecting the data range!

2. Click on Insert, choose Column under the Charts group, and select one of the subtypes (for example, Clustered Column).

Select Chart Type

 

Result:

Column Chart

With just a few clicks this already looks really nice. Let’s take a look at some other chart features.

 

Switch Row/Column

If you want the quarters, displayed on the horizontal (category) axis, to be displayed on the vertical (value) axis instead, you can switch rows to columns.

1. Select the chart. The Chart Tools contextual tab activates.

2. Click on the Design tab and click on Switch Row/Column under the Data group.

Siwtch Row/Column

Result:

Switched Column Chart

Add Chart Title

Our Chart needs a title because at the moment it is unclear what the numbers represent.

1. Select the chart. The Chart Tools contextual tab activates.

2. On the Layout tab, click on Chart Title, and select Above Chart.

Add a Title

3. Type the title. For example, Profits.

Result:

 

Click Here To Continue Reading

Replies (1)

Awsomme sharing sir.............................

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details