Excel 2024: Paste New Data on a Chart


March 18, 2024 - by Bill Jelen

Excel 2024: Paste New Data on a Chart

You might be responsible for updating charts every month, week, or day. For example, in my last job, a collection of charts were updated during the month-end close process. The charts would track progress throughout the year.

There is an easy way to add new data to an existing chart. Here, the chart shows data for January through May, and there is new data for June that is not on the chart.

A chart is shown with five months of data. In the worksheet grid, you can see a new data point for June has been added.
A chart is shown with five months of data. In the worksheet grid, you can see a new data point for June has been added.

Rather than re-create the chart, you can paste new data on it. Select the new data in the worksheet, including the heading. Press Ctrl+C to copy.

continue reading »

More Reading


Excel 2024: Create Perfect One-Click Charts

Excel 2024: Create Perfect One-Click Charts »

March 15, 2024 - by Bill Jelen


One-click charts are easy: Select the data and press Alt+F1. What if you would rather create bar charts instead of the default clustered column chart?

Excel 2024: New Threaded Comments Allow Conversations

Excel 2024: New Threaded Comments Allow Conversations »

March 12, 2024 - by Bill Jelen


Threaded comments debuted in 2018. When you insert a comment, Excel stores the comment, the author, the date, and time. When a co-worker sees your comment, they can click Reply and add a new comment to the same cell. Each set of comments lists the author, date, and time.

Excel 2024: Save Filter & Sorting in Sheet View

Excel 2024: Save Filter & Sorting in Sheet View »

March 11, 2024 - by Bill Jelen


Do you share a workbook with co-workers? Does you co-worker want to Filter or Sort the workbook differently than you do? Eight years ago, I was ready to strangle my co-worker Scott when he kept filtering our project list to show only his projects.

read more articles »

Featured Products


Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.


Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.


Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!


see more products »