Excel 2024: Paste New Data on a Chart
March 18, 2024 - by Bill Jelen
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.
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.