Easily Paste Extra Data Into Your Excel Chart


If you have extra data that you need to add into your charts, then the usual way in Excel 2007 onwards of adding data is to drag the blue box line with the mouse but this will work only if your chart and data is on the same page????

Drag Data Into Chart

 

 

 

– my charts and data these days are rarely on the same page, so what can we do?…

We can copy and paste!  Just hit CTRL+C on the data set including the heading that you want to add into your chart and then go to your chart and paste the data right into the data area of the chart.

In my example it is Aug 13 Sales that I have copied and pasted. There you go data pasted!.

 

Paste Excel Data 2

 

 

 

More Excel Tips

Change Your Default Chart In Excel

Add A Trend Line To Your Excel Chart

Create Dynamic Titles In Excel Charts

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts