How to quickly make multiple charts in excel

In this video I show you how to copy the same chart multiple times and then change the cell references it is linked to in order to make lots of similar charts.
--------------------------------------------------------------------------------
#exceltips #exceltutorials #excelcharts

Microsoft Office 365, 2016, Office Insider, Version 1906

These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:

[johnk.]

This was incredibly helpful! I have dozens of workbooks with dozens of rows/columns of data that I need to graph 1 by 1 - this will give me literal days back to my life. THANK YOU!

[ranjittribhuvane]

Thank you. Few months back I saw this clip. Use it and forgot it. Again when I am in need, i watch it again and I will use it. Thank you!

[thx]

You just saved me 2-3 hours of weekend work time, thank you :)

[maksim]

Nice lessons, please do not stop making new lessons, very appreciated)

[Tascioni]

Thank you thank you so much. Super easy and simple, other videos ask you to download add-ins an other stuff. But this method is just ridiculously simple and efficient. Thank you.

[bassemghorab]

Goddd I've been searching this for so long because I have over 100 graphs to make. THANKS!!

[matthewkukundakwe]

This is really helpful..
thank you very much

[karinaadcock]

Hope you learnt something new and interesting. Thanks for watching and don't forget to Like, Comment and Subscribe.

[AlcatraZJGroup]

Thank you so much, very clear instruction. Subscibed!

[carolhorlock]

Fabulous, just what I needed :) thank you

[pravindiliban]

Thank you for the explanation, I would like to know is there any possibility to have a common legend for the shown graphs

[fankitty]

Hi Karina, thanks for the video. Super helpful. Just wondering if there's a way to create a graph for multiple sheets when the sheets have the same layout table just different figures? And I want to create a graph next to the table for each sheet in an effecient manner. Currently doing it manually.

[hariramdevkota]

I got some problems related to excel spreadsheet data presentation in mass. It is also the data for dessertation and couldn't overcome it. How shall I contact you?

[bharatkerajamaharajaauradb]

Can we set more than 20 graph 📊 in single sheet

[austinedwards]

Is there a way of doing this without multiple copy and pastes? In my case I’ve got around 30 graphs to make. I’d rather not change the cells for each one manually.

[JennaHills]

This is so useful. A question... I have legends because I am using multiple bar charts. All the legends have used the default name "series1, series2, etc. I want to them all to reference the top row of the source data table. How can I update the series names of multiple charts? Now, I have to edit each series name, but I have 100s. It'll take an age. Any ideas?