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 ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

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
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details