Bird
Raised Fist0
Excelspreadsheet~5 mins

Selecting data for charts in Excel - Step-by-Step Guide

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Introduction
Selecting data for charts helps you show the right information visually. It solves the problem of making charts that reflect exactly the numbers or categories you want to highlight.
When you want to create a sales chart showing only the last quarter's data.
When you need a chart that compares product categories from a specific region.
When you want to update a chart to include new monthly data without recreating it.
When you want to exclude some rows or columns from the chart to focus on key points.
When you want to create multiple charts from different parts of the same data table.
Steps
Step 1: Select the cells containing the data you want to chart
- Worksheet grid
The selected cells are highlighted with a colored border
💡 Include both labels (like months or categories) and numbers for clear charts
Step 2: Click the Insert tab
- Ribbon at the top of Excel
The Insert tab options appear, showing chart types
Step 3: Click the chart type you want (e.g., Column, Line, Pie)
- Charts group on the Insert tab
Excel inserts a chart on the worksheet using the selected data
Step 4: Click the chart to select it
- Chart area on the worksheet
Chart Tools tabs (Design and Format) appear in the ribbon
Step 5: Click the Design tab under Chart Tools
- Ribbon
Chart design options appear
Step 6: Click Select Data
- Data group on the Design tab
The Select Data Source dialog box opens, showing current data ranges
Step 7: Edit the Chart data range or add/remove series as needed
- Select Data Source dialog box
The chart updates to reflect the new data selection after clicking OK
Before vs After
Before
Worksheet shows sales data for all 12 months in columns A and B; no chart is present
After
A column chart appears showing sales data for only the selected 6 months from columns A and B
Settings Reference
Chart data range
📍 Select Data Source dialog box
Defines which cells Excel uses to build the chart
Default: The initially selected cells when creating the chart
Legend Entries (Series)
📍 Select Data Source dialog box
Controls which data series appear in the chart
Default: All series from the selected data range
Horizontal (Category) Axis Labels
📍 Select Data Source dialog box
Sets the labels shown on the chart's horizontal axis
Default: Labels from the first column or row of the data range
Common Mistakes
Selecting only the numbers without the labels before inserting the chart
The chart will not show meaningful category names, making it hard to understand
Always include the labels (like months or product names) along with the numbers when selecting data
Not updating the data range after adding new data
The chart will not include the new data and will look outdated
Use the Select Data option to update the data range or create a dynamic named range
Summary
Selecting data for charts means choosing the exact cells that hold the numbers and labels you want to show.
You can change or update the data range anytime using the Select Data option under Chart Tools Design tab.
Always include labels with numbers to make charts clear and easy to understand.

Practice

(1/5)
1. What is the best way to select data for creating a chart in Excel?
easy
A. Select only the labels without numbers
B. Select only the numbers without labels
C. Select random cells from different parts of the sheet
D. Select both the labels and the numbers together in a continuous range

Solution

  1. Step 1: Understand chart data requirements

    Charts need both labels (like names or categories) and numbers (values) to display meaningful information.

  2. Step 2: Select data properly

    Selecting both labels and numbers together in a continuous range ensures Excel can link labels to their values correctly.

  3. Final Answer:

    Select both the labels and the numbers together in a continuous range -> Option D

  4. Quick Check:

    Labels + numbers together = correct chart data [OK]
Hint: Always include labels and numbers in one continuous selection [OK]
Common Mistakes:
  • Selecting only numbers without labels
  • Selecting non-adjacent cells
  • Selecting only labels without numbers
2. Which of the following is the correct way to select data for a chart in Excel?
easy
A. Click and drag to select labels in A1:A5 and numbers in C1:C5 separately
B. Select only the header row
C. Click and drag to select a continuous range like A1:B5 including labels and numbers
D. Select cells randomly across the sheet

Solution

  1. Step 1: Check selection continuity

    Charts require a continuous block of data including labels and numbers for proper linking.

  2. Step 2: Choose continuous range

    Selecting A1:B5 includes both labels and numbers in one block, which Excel uses correctly for charts.

  3. Final Answer:

    Click and drag to select a continuous range like A1:B5 including labels and numbers -> Option C

  4. Quick Check:

    Continuous range selection = correct syntax [OK]
Hint: Select one continuous block including labels and numbers [OK]
Common Mistakes:
  • Selecting non-adjacent columns separately
  • Selecting only headers without data
  • Selecting random cells not in a block
3. Given this data in Excel:
A1: Month
A2: Jan
A3: Feb
A4: Mar
B1: Sales
B2: 100
B3: 150
B4: 120

If you select the range A1:B4 and insert a chart, what will the chart show?
medium
A. A chart with months on the X-axis and sales numbers as bars
B. A chart with sales numbers on the X-axis and months as bars
C. An error because labels and numbers are not selected
D. A blank chart with no data

Solution

  1. Step 1: Identify selected data

    The range A1:B4 includes the header labels "Month" and "Sales" plus the data for months and sales numbers.

  2. Step 2: Understand chart axis assignment

    Excel uses the first column (Month) as X-axis labels and the second column (Sales) as values for the chart bars.

  3. Final Answer:

    A chart with months on the X-axis and sales numbers as bars -> Option A

  4. Quick Check:

    Labels in first column = X-axis [OK]
Hint: First column labels become X-axis, second column values become bars [OK]
Common Mistakes:
  • Confusing which axis shows labels
  • Selecting only numbers without labels
  • Expecting error when data is correctly selected
4. You tried to create a chart but Excel shows incorrect labels on the X-axis. You selected the range B1:C5 where B1:C1 are headers and B2:C5 are numbers. What is the likely problem?
medium
A. You did not include the label column in your selection
B. You selected too many rows
C. You selected non-adjacent columns
D. You included headers which Excel cannot use

Solution

  1. Step 1: Analyze selected range

    The range B1:C5 includes headers and numbers but no label column (like names or categories) for the X-axis.

  2. Step 2: Understand chart label requirement

    Charts need a label column to show meaningful X-axis labels; missing it causes incorrect or default labels.

  3. Final Answer:

    You did not include the label column in your selection -> Option A

  4. Quick Check:

    Missing label column = wrong X-axis labels [OK]
Hint: Always include label column for correct X-axis labels [OK]
Common Mistakes:
  • Assuming headers cause errors
  • Selecting too many rows is a problem
  • Selecting non-adjacent columns is allowed
5. You have sales data for 3 products over 4 quarters in this layout:
A1: Product, B1: Q1, C1: Q2, D1: Q3, E1: Q4
A2: ProdA, 100, 120, 130, 140
A3: ProdB, 90, 110, 115, 125
A4: ProdC, 80, 105, 110, 120

To create a chart comparing sales per quarter, which data range should you select?
hard
A. Select B1:E4 to include only sales numbers without product names
B. Select A1:E4 to include all products and quarters
C. Select A1:A4 to include only product names
D. Select A2:E2 to include only first product's data

Solution

  1. Step 1: Understand chart goal

    You want to compare sales per quarter for all products, so you need all product names and all quarter sales.

  2. Step 2: Select full data including labels

    Selecting A1:E4 includes product names (A column) and all quarter sales (B to E columns) with headers, giving Excel full data for the chart.

  3. Final Answer:

    Select A1:E4 to include all products and quarters -> Option B

  4. Quick Check:

    Include labels + all data for full comparison [OK]
Hint: Select entire table including headers and labels [OK]
Common Mistakes:
  • Selecting only numbers without labels
  • Selecting only one product's data
  • Selecting only labels without numbers