How to Update Chart in Excel

Updating a chart in Excel shouldn't feel like wrestling with a spreadsheet. Whether you've added new monthly sales data or need to tweak the visual style, making changes to your graphs is straightforward once you know where to look. This post will walk you through several easy methods for updating your Excel charts, from adding new data points instantly to completely changing the chart’s appearance.

Understanding How Excel Charts Link to Your Data

Before making changes, it helps to understand a fundamental concept: an Excel chart is a visual reflection of your source data. It’s directly linked to a specific range of cells in your worksheet. When you select a chart, Excel highlights this source range, typically with colored borders. Any changes you make to the numbers within that range will instantly update on your chart. The challenge most people face is when they need to expand that range to include new rows or columns of information.

For example, let's say you have this simple dataset of Q1 sales:

Your bar chart visually represents cells A1 through B4. If you add "April" and its sales figure in row 5, your chart won't automatically see it. The key to updating a chart is telling Excel, "Hey, the source data range is bigger now."

How to Add New Data to an Excel Chart

Let's look at the most common task: adding new data to an existing graph. Here are a few different ways to accomplish this, from the fast and simple to the resilient and automated.

Method 1: The Quick Drag-and-Drop

This is by far the fastest way to expand your chart's data range if your new data is right next to your old data.

Step 1: Click on your chart to select it. When you do, you'll see a blue border appear around the current source data in your spreadsheet.
Step 2: Move your mouse cursor to the small square handle in the bottom-right corner of that blue border. Your cursor will change to a diagonal two-headed arrow.
Step 3: Click and drag that corner down (or across) to include the new rows or columns you've added.

As you drag, a faint outline will show the expanding range. Once you release the mouse button, your chart will instantly update to include the new data points. This method is perfect for quick, on-the-fly additions.

Method 2: Using the 'Select Data' Window

For more control, or if your data isn't arranged perfectly next to the original source, the "Select Data" dialog box is your best friend. This lets you manually define exactly what data the chart should include.

Step 1: Right-click anywhere on your chart and choose Select Data… from the context menu.
Step 2: A window called "Select Data Source" will pop up. You’ll see a field at the top named "Chart data range:". This box shows the current range the chart is using (e.g., =Sheet1!$A$1:$B$4).
Step 3: Click the small icon at the right end of this field (it looks like a little spreadsheet with a red arrow). The window will contract, allowing you to click and drag over the entire new data range in your worksheet, including the new data you've added.
Step 4: Once you've selected the new, larger range, press 'Enter' or click the icon again to confirm. The "Select Data Source" window will reappear with the updated range.
Step 5: Click OK. Your chart is now updated with the new information.

This 'Select Data' window also lets you add, edit, or remove individual data series (the "Legend Entries" on the left) and change the Horizontal Axis Labels on the right, giving you complete control over your chart’s components.

Method 3: Turn Your Data into an Excel Table (for Automatic Updates)

If you're constantly adding new data to a chart (like a monthly sales report or weekly traffic log), updating it manually - even with the quick drag-and-drop method - can get tedious. This is where Excel Tables shine. By formatting your source data as an official Table, your chart becomes dynamic and updates itself automatically whenever you add new data.

This is a game-changer and the best-practice method for recurring reports.

How to Set It Up

Step 1: Convert your range to a Table. Click anywhere inside your data range and press Ctrl + T on your keyboard (or go to the Insert tab and click Table). Excel will ask you to confirm the range and whether your data has headers. Make sure "My table has headers" is checked if it does, then click OK.
Step 2: Style your Table (Optional). Your data will now have a new look, usually with alternating row colors. You can change this style using the "Table Design" tab that appears in the Ribbon when your Table is selected.
Step 3: Create your chart. With a cell in your new Table selected, go to the Insert tab and choose the chart type you want (e.g., Bar, Line, Pie). Excel will create a chart based on the Table data.

The Automatic Update in Action

Now for the fun part. Go to the first empty row right below your Table. Start typing your new data (e.g., the next month's sales figures). As soon as you hit 'Enter,' you’ll notice two things:

The Table will automatically expand to include your new row, applying its formatting.
Your chart will instantly and automatically update to include the new data point you just added.

No dragging, no right-clicking, no selecting data. The Table and the chart are dynamically linked. This single step saves countless hours for anyone who builds regular reports in Excel.

How to Update a Chart's Style and Appearance

Updating a chart isn’t only about the data, it's also about making it clear, readable, and professional. Once your chart is selected, you'll see three small icons appear on its top-right side: Chart Elements (+), Chart Styles (paintbrush), and Chart Filters (funnel).

Change the Chart Type

Sometimes a bar chart doesn't tell the full story, and you need a line chart to show a trend. Changing the type is simple.

Right-click your chart and select Change Chart Type…
A dialog box appears with all the available chart types on the left.
Select a new type, like "Line," choose a style you like, and click OK. Your data is instantly re-visualized without losing any information.

Add or Remove Chart Elements

Need to add a title or data labels for clarity? Use the "Chart Elements" menu (the plus + icon).

Click the + icon and check the box next to any elements you want to add, such as:

Axis Titles: Essential for labeling what your X and Y axes represent.
Chart Title: Give your chart a clear, descriptive headline.
Data Labels: Show the exact value for each bar or point on your chart directly on the visual.
Legend: A key that explains what each data series (color) represents. Useful when you have multiple series.
Trendline: Adds a line to your chart that shows the overall trend in your data series.

Unchecking any of these boxes will remove the corresponding element.

Quickly Adjust Visual Styles and Colors

For a fast, professional makeover, use the "Chart Styles" menu (the paintbrush icon).

Style: This tab gives you a gallery of professionally-designed themes. These presets adjust fonts, effects, and layouts with a single click.
Color: This tab provides pre-set color palettes, including monochromatic schemes and colorful ones, allowing you to quickly change the look and feel or align the chart with your brand’s colors.

Final Thoughts

From a simple drag-and-drop to expand a data range to setting up a dynamic Excel Table that updates automatically, you now have a full toolset to keep your charts current and insightful. Mastering these methods means you can spend less time wrangling your visuals and more time using them to make smart decisions.

While Excel is fantastic, creating reports can still feel like manual work, especially when you need to pull data from different places like Google Analytics, Shopify, or Salesforce first. We created Graphed to solve this issue. Instead of downloading CSVs and building reports from scratch, you can connect your accounts directly and ask for a dashboard using plain English. We turn hours of reporting work into a 30-second conversation, giving you live dashboards that always stay up-to-date automatically.