AccountancyCBSE Class 12 · Graphs and Charts for Business Data

Steps to Create a Chart in a Spreadsheet: Class 12 Method and Chart Tools

Updated 15 October 2026 · Fact-checked

To create a chart, enter the data with row and column headings, select the range including the headings, and choose a chart type and sub-type from Insert → Charts. The Chart Tools (Design, Layout, Format tabs) then let you change the type, switch rows and columns, add titles, legends and labels, and move or resize the chart.

Follow the five steps in order, and remember the chart stays linked to the data, so changing values updates it automatically.

Illustration drawn for QuestionBuddy.

Understand Steps to Create a Chart

Step 1: arrange the data. Put categories (for example quarters) in the first column and series (for example products) in the first row, with values in the grid. Headings become the chart's category labels and legend entries. Avoid blank rows or columns inside the range.

Step 2: select the range including headings (use Ctrl to select non-adjacent ranges, such as names and one column of values).

Step 3: Insert → Charts group → choose a type (Column, Line, Pie, Bar, Area, Scatter, Other charts) and a sub-type (clustered, stacked, 100% stacked, 2-D, 3-D). The chart appears on the worksheet.

Step 4: refine with Chart Tools (shown when the chart is selected):

Design tab: Change Chart Type; Switch Row/Column (swap what is on the category axis and in the legend); Select Data (add, remove or edit series and ranges); Chart Layouts and Chart Styles; Move Chart (to another sheet or a new chart sheet).
Layout tab: add or remove chart title, axis titles, legend, data labels, data table, axes and gridlines.
Format tab: fill, outline, effects and text formatting of the selected element.

Step 5: resize and position by dragging the chart's handles; save the workbook.

Charts are linked to data. When the source values change, the chart updates automatically.

Keyboard shortcut. Selecting data and pressing F11 creates a default chart on a new chart sheet (Alt + F1 creates one on the same sheet).

Steps to Create a Chart: key facts

Basic path: 1.Enter data
2.select range
3.Insert
4.Charts
5.type
6.sub-type
Chart Tools tabs: Design (type, data, layout, style, move); Layout (titles, legend, labels, axes); Format (fill, outline, effects); Newer versions merge Layout into Design and Format.
Switch Row/Column: Swaps categories on the axis with series in the legend

How to answer Steps to Create a Chart questions

'Steps' questions are scored step by step; write them in order with menu paths.

1Enter or arrange data with headings.
2Select the range including headings.
3Insert → Charts → choose the type suited to the message → sub-type.
4Add chart and axis titles, legend and data labels from Chart Tools.
5Use Switch Row/Column or Select Data if the series are the wrong way round.
6Move or resize the chart and format it for readability.

Steps to Create a Chart in real life

The idea, met in an everyday situation. Answer the question in your own words, then compare with the model answer. The one-line hook is what to remember.

Switch Row/Column

Suppose a manager enters quarterly sales of three products with quarters as rows and products as columns, and inserts a clustered column chart. The chart groups bars by quarter, but she wants to compare how each product did across the four quarters.

What single command fixes this and what does it change?

Try it first, then show the solutionSolution

Select the chart; Chart Tools → Design → Switch Row/Column.
Products move to the category axis; quarters become the legend series.
Each product now has four bars side by side, one per quarter.

Answer: Switch Row/Column swaps the category axis and the legend, so the bars are grouped by product with one bar per quarter, making each product's quarterly performance easy to compare.

Memory hook: Wrong grouping? Switch, don't retype.

Tricks to remember Steps to Create a Chart

Short memory aids. Say each one aloud once, then use it on a question the same day.

A-S-I-R
Arrange, Select, Insert, Refine.
Use it when: Four main steps.
Design-Layout-Format
Design changes what the chart is; Layout what it shows; Format how it looks.
Use it when: Chart Tools tabs.
F11 for a fast chart
Select data and press F11 for an instant chart sheet.
Use it when: Shortcut MCQs.

Steps to Create a Chart: solved examples

Ordered from board level to HOTS. Try each one before you open the solution.

Example 1: Where are charts inserted? · 1 mark · MCQBoard level

Charts are created from the:
(a) Home tab
(b) Insert tab
(c) Data tab
(d) View tab

Try it first, then show the solutionSolution

Insert → Charts group.

Answer: (b) Insert tab

Example 2: Steps for a column chart · 3 marks · Short answerBoard level

Write the steps to create a clustered column chart of quarterly sales of three products and give it a title. (3 marks)

Try it first, then show the solutionSolution

Enter quarters in A2:A5, products in B1:D1 and sales in B2:D5; select A1:D5.
Insert → Charts → Column → Clustered Column.
Chart Tools → Layout (or Chart Elements) → Chart Title → Above Chart; type the title.

Answer: As listed.

Example 3: Chart Tools tabs · 3 marks · Short answerHarder board level

Name the three Chart Tools tabs and give two commands available on each. (3 marks)

Try it first, then show the solutionSolution

Design: Change Chart Type; Switch Row/Column (also Select Data, Move Chart, styles).
Layout: Chart Title; Legend (also Data Labels, Axes, Gridlines).
Format: Shape Fill; Shape Outline (also effects, WordArt styles).

Answer: As listed.

Example 4: Non-adjacent data · 3 marks · Short answerHarder board level

Product names are in column A, last year's sales in column B and this year's in column C. How would you chart only product names and this year's sales? (3 marks)

Try it first, then show the solutionSolution

Select A1:A10, then hold Ctrl and select C1:C10.
Insert → Charts → choose a column or bar chart.
Alternatively, insert the chart and use Design → Select Data to remove the column B series.

Answer: Select the two ranges with Ctrl (or edit series with Select Data) before inserting the chart.

Example 5: Charts and data · 1 mark · Assertion-reasonHOTS / competency

Assertion (A): A chart created from worksheet data must be redrawn whenever the data change.
Reason (R): A chart is linked to its source data and updates automatically when the values change.
(a) Both A and R are true, and R is the correct explanation of A.
(b) Both A and R are true, but R is not the correct explanation of A.
(c) A is true, but R is false.
(d) A is false, but R is true.

Try it first, then show the solutionSolution

Charts are dynamic; no redrawing is needed. A is false, R is true.

Answer: (d) A is false, but R is true.

Where students lose marks in Steps to Create a Chart

The slips examiners see most often, and what to write instead.

Mistake: Selecting data without headings
Selecting only numbers.
Wrong working
Legend shows 'Series1, Series2'.
Right working
Include headings so series and categories are named.
Do this: Select from the top-left heading cell.
Usually costs: 1/2 mark.
Mistake: Wrong tab in the path
Guessing.
Wrong working
Home → Chart.
Right working
Insert → Charts.
Do this: Charts are inserted objects.
Usually costs: 1/2 mark.
Mistake: Retyping data to swap the axes
Not knowing Switch Row/Column.
Wrong working
Rearranging the worksheet.
Right working
Design → Switch Row/Column.
Do this: Use the command.
Usually costs: 1 mark in case questions.
Mistake: Omitting the chart type choice
Writing 'insert chart' only.
Wrong working
'Click Insert and then chart.'
Right working
'Insert → Column → Clustered Column.'
Do this: Name type and sub-type.
Usually costs: 1/2 mark.

Exam tips

Write steps as a numbered list with menu arrows.
Mention selecting headings; it explains the legend and axis labels.
Name Chart Tools tabs exactly.
Steps to create a chart are frequently asked as 4-mark questions in this chapter.

Practice questions on Steps to Create a Chart

Write each answer on paper first. Open the hint only if you are stuck, and the answer only when you have finished.

Q1 · 1 mark · MCQBoard level
Which command swaps the data shown on the category axis with the data in the legend?
(a) Change Chart Type
(b) Switch Row/Column
(c) Select Data
(d) Move Chart
Hint
Rows ↔ columns.
Answer
(b) Switch Row/Column
Q2 · 1 mark · MCQBoard level
Pressing F11 after selecting data:
(a) deletes the data
(b) creates a chart on a new chart sheet
(c) opens Data Validation
(d) prints the sheet
Hint
Quick chart.
Answer
(b) creates a chart on a new chart sheet
Q3 · 1 mark · Very short answerHarder board level
How do you move a chart to a separate chart sheet? (1 mark)
Hint
Design tab.
Answer
Select the chart → Chart Tools → Design → Move Chart → New sheet → OK.
Q4 · 3 marks · Short answerHarder board level
How do you change an existing column chart into a pie chart, and what must you check? (3 marks)
Hint
One series.
Answer
Select the chart → Design → Change Chart Type → Pie → OK. Check that only one data series is plotted, since a pie chart shows a single series; remove extra series with Select Data if needed.
Q5 · 3 marks · Short answerHarder board level
Explain the use of 'Select Data' in charts. (3 marks)
Hint
Edit series and ranges.
Answer
Select Data (Design tab) opens a dialog to change the chart's source range, add or remove series, edit a series' name or values, and edit category (axis) labels, without recreating the chart.
Q6 · 1 mark · Assertion-reasonHarder board level
Assertion (A): Data used for a chart should have row and column headings.
Reason (R): Headings become the category labels and legend entries of the chart.
(a) Both A and R are true, and R is the correct explanation of A.
(b) Both A and R are true, but R is not the correct explanation of A.
(c) A is true, but R is false.
(d) A is false, but R is true.
Hint
Labels.
Answer
(a) Both A and R are true, and R is the correct explanation of A.
Q7 · 4 marks · Short answerHOTS / competency
Suppose you must show total sales of each quarter (not each product) in a pie chart from a table of 4 quarters × 3 products. Describe the steps. (4 marks)
Hint
Add a total column first.
Answer
Add a Total column with =SUM(B2:D2) copied down for each quarter. Select the quarter names and the Total column (using Ctrl for non-adjacent ranges). Insert → Pie → choose a sub-type. Add a title and data labels showing percentages.
Q8 · 3 marks · Short answerHOTS / competency
A chart's legend shows 'Series1, Series2, Series3' and the axis shows 1, 2, 3, 4 instead of quarter names. Diagnose and fix. (3 marks)
Hint
Headings were not selected.
Answer
The headings were left out of the selection, so Excel used default names. Fix with Design → Select Data: edit each series name to the product heading cell and edit the horizontal axis labels to the quarter names (or recreate the chart selecting headings).

Test your recall

Answer in your head or on paper first, then open the card. Pulling an answer out of memory makes it stick far better than re-reading.

1.First step in creating a chart?Show answer
Enter and arrange the data with headings.
2.Which tab has the Charts group?Show answer
Insert.
3.Which Chart Tools tab has Change Chart Type?Show answer
Design.
4.Do charts update when data change?Show answer
Yes, automatically.
5.Key that creates an instant chart sheet?Show answer
F11.

Steps to Create a Chart: frequently asked questions

What are the basic steps to create a chart in Class 12?

Enter data with headings, select the range, choose a chart type and sub-type from Insert → Charts, then refine it with Chart Tools.

What are Chart Tools?

Contextual tabs (Design, Layout, Format) that appear when a chart is selected, used to change type, data, elements and formatting.

How can I chart non-adjacent columns?

Hold Ctrl while selecting the ranges, or adjust series with Select Data after inserting the chart.

What does Switch Row/Column do?

It swaps the data plotted on the category axis with the data shown as series in the legend.