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

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.