How to Select Data Range in Excel for Chart

Turning a spreadsheet of raw numbers into a clear, insightful chart is one of the most powerful features in Excel. But before you get to the finished visual, you have to master a fundamental first step: selecting the right data. This article guides you through the various ways to select a data range for your chart, from the simple click-and-drag method to more advanced techniques that will save you time every week.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Simplest Method: Selecting a Contiguous Block of Data

Let's start with the most common scenario. You have a clean, simple block of data where all your information is arranged in adjacent rows and columns, with no blank rows or columns in the middle. This is known as a contiguous data range.

Imagine you have a small table tracking monthly website traffic:

Month   | Sessions | Pageviews
--------|----------|----------
January | 10,500   | 21,300
February| 11,200   | 22,800
March   | 13,000   | 26,500
April   | 12,100   | 24,000

Selecting this data is straightforward. You have two primary options:

Method 1: Click and Drag

This is the method most people learn first because it’s so intuitive.

• Click your mouse on the top-left cell of your data range (in this case, the cell containing "Month").
• Hold the left mouse button down.
• Drag your cursor down and to the right until you’ve highlighted the entire block of data, including the headers.
• Let go of the mouse button.

Your entire data set is now selected and ready for you to create a chart via the Insert tab.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Use the Shift Key

For larger data sets, clicking and dragging can be tedious and prone to error. Using the Shift key is often faster and more precise.

• Click once on the top-left cell of your data range ("Month").
• Scroll to the end of your data set, if necessary.
• Hold down the Shift key on your keyboard.
• While holding Shift, click once on the bottom-right cell of your range (the cell with the number 24,000).
• Let go of the Shift key.

Excel will instantly select all the cells between your first and second click. This is a much more efficient way to select large, unbroken blocks of data.

Working with Non-Adjacent Data: The Ctrl/Cmd Key Method

What if the data you want to plot isn't sitting right next to each other? This is a very common situation. For example, you might want to create a chart that compares the month to the profit, but you want to ignore the columns for revenue and expenses in between.

Consider this data:

Month   | Revenue | Expenses | Profit
--------|---------|----------|--------
January | $5,000  | $3,000   | $2,000
February| $5,500  | $3,200   | $2,300
March   | $6,200  | $3,500   | $2,700
April   | $5,800  | $3,300   | $2,500

To create a chart showing just the Month and the final Profit, you need to select non-contiguous (or non-adjacent) data ranges. Trying to do this with the click-and-drag method won't work.

Here’s the trick: use the Ctrl key (on Windows) or the Cmd key (on Mac).

1. First, select your initial data range just as you normally would. In this case, click and drag to highlight the "Month" column, including its header (e.g., cells A1 through A5).
2. Now, press and hold the Ctrl key (or Cmd on a Mac).
3. With the key held down, select your next data range. Click on the "Profit" header (cell D1) and drag down to select all the profit figures (down to cell D5).
4. Release the Ctrl/Cmd key. You should see both columns highlighted, with the columns in between left unselected.

A quick tip: For this to work correctly, your selections must have the same number of rows. If you select five cells in the first column, you must also select five cells in the second column.

Now, when you go to Insert > Chart, Excel will know to use the first column for your axis labels and the second column for your data values, neatly ignoring the information you didn't highlight.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Updating an Existing Chart with New Data

Your spreadsheet is rarely static. You'll add new rows of data over time - like sales results from a new month. Instead of deleting your chart and starting over, you can simply update the data range it's using.

Method 1: The Simple Drag-and-Drop

This is the quickest way to update a chart when you've just added new data right below your existing table.

1. Click on your existing chart. When it's selected, you'll see your source data highlighted on the spreadsheet in one or more colored boxes.
2. Look closely at the corner of the highlighted data box. You'll see a small square handle.
3. Hover your cursor over that handle until it turns into a two-sided arrow.
4. Click and drag the handle down to include your new rows (or across to include new columns).
5. Release the mouse button. Your chart will instantly update to include the new data.

This method works best for simple additions to a contiguous data block. For more complex changes, the next method is better.

Method 2: Using the "Select Data Source" Dialog Box

The "Select Data Source" window gives you complete control over every piece of data in your chart. It's the most powerful and precise way to manage your chart's source data.

1. Right-click anywhere on your chart.
2. From the context menu, choose Select Data…. A dialog box will appear.
3. In this box, you'll see a field called Chart data range. You can manually edit this field or click the icon next to it to re-select your entire range on the spreadsheet.
4. You can also modify individual data series (the lines, bars, or columns in your chart). Under Legend Entries (Series), you can click Add, Edit, or Remove. Clicking "Edit" allows you to precisely define the cells used for the series name and its values.
5. Similarly, you can edit the Horizontal (Category) Axis Labels to make sure your x-axis is pulling labels from the correct cells.

This dialog box is perfect for making specific edits, adding a data series from a completely different part of your spreadsheet, or troubleshooting a chart that isn't displaying correctly.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Going Pro: Creating Dynamic Chart Ranges with Excel Tables

If you find yourself constantly dragging the resize handle or editing the data source every week, there's a much smarter way to work. By formatting your data as an official Excel Table, your charts can update automatically whenever new data is added.

This is a game-changer for anyone who manages recurring reports.

1. Start with your raw, unformatted data range. Click any cell within it.
2. Press Ctrl + T on your keyboard (or go to Insert > Table on the ribbon).
3. A small box will pop up confirming the data range. Make sure the "My table has headers" box is checked if your columns have titles. Click OK.
4. Your data will now be formatted with colored bands and filter buttons in the headers. It is now an official Excel Table.
5. Now, with a cell in the table selected, create your chart as usual (Insert > Recommended Charts, etc.).

Here’s the powerful part: The chart is now linked to the Table object, not a fixed range of cells. The next time you need to add data, simply go to the cell directly below the last row of your table and start typing. The table will automatically expand to include your new row, and your chart will instantly and automatically update to plot the new data. No dragging, no editing, no re-selecting anything.

Final Thoughts

Mastering how you select data in Excel is the first step toward creating accurate and compelling charts. From a simple contiguous block to complex, non-adjacent ranges, and finally to dynamic charts based on Excel Tables, knowing the right technique for the job saves a ton of time and makes your entire reporting workflow more efficient.

Of course, building charts in Excel is often just one step in a much longer manual reporting process. For many teams, true efficiency comes from automating the entire data gathering and visualization workflow. Here at Graphed, we built a tool to eliminate this manual work entirely. We let you connect your data sources — like Google Analytics, Shopify, and Facebook Ads — and use simple, natural language to create real-time dashboards in seconds. It’s like having a data analyst ready to build the reports you need, right when you ask for them. If you’re ready to get back the hours spent wrangling spreadsheets, you can try Graphed for free.