Тёмный

MS Excel - Combining Two Graphs Into One! Cool Trick! 

Jellyman Education
Подписаться 13 тыс.
Просмотров 157 тыс.
50% 1

To get your FREE Tableau Beginner Training course, check out my website at:
www.udemy.com/course/tableau-...
-----------------------------------------------
SUBSCRIBE for new videos Tuesday-Thursday. Click the notification bell so you don't miss a single episode.
GOT A QUESTION/PROBLEM? Why not request a video using the Comments section below. I'll make a custom video just for you.
----------------
VIDEO DESCRIPTION:
Working with graphs in Excel can be very fun. However, it never hurts to learn a few tricks along the way. In this video I'll show you how to quickly combine or move one graph into another! A great Excel trick!
----------------
Want to upskill to the next level of Tableau? Consider learning Tableau!
TRAINING COURSES:
Udemy - Complete Tableau Training Course
-Over 184k students and over 13k reviews!
-200 Lectures and 22 hours of Tableau Content
www.udemy.com/course/tableau-...
SkillShare Tableau Training
www.skillshare.com/profile/Je...
------------------------------------------------------------------
RU-vid PLAYLISTS:
Tableau for Beginners - A Quick Start RU-vid Course
• Tableau for Beginners ...
Tableau Desktop Accelerator RU-vid Course - A Beginners Guide for New Users
• Tableau Desktop Accele...
Tableau Online/Server Short Course - Site Creation, User Management and Licensing
• Tableau Online/Server ...
Tableau Online/Server - Complete Playlist
• Tableau Online/Server ...
Tableau Desktop - Complete Playlist
• Tableau Desktop - Comp...
Tableau Prep - Complete Playlist
• Tableau Prep - Complet...
#Tableau
------------------------------------------------------------------------------
RECORDING EQUIPMENT (Amazon Affiliate Program) -
VIDEO DESCRIBING EACH ( • My Recording Equipment... )
Headset: Sennheiser GSP 350 - Dolby 7.1 Surround, Noise Canceling, headset volume control
amzn.to/32N8vpz
Keyboard 1: Logitech Illuminated K830 Wireless Keyboard with Touchpad
amzn.to/2IIcHzn
Keyboard 2: Logitech MX Wireless Illuminated Keyboard
amzn.to/36BAIk4
Mouse: Logitech MX Master 2S
amzn.to/32KMaso (My current model)
amzn.to/2IF5C2G (Latest Model MX Master 3)
Laptop Stand: Adjustable/Tilting Laptop Stand Aluminum
amzn.to/2Uuj7F7
Monitor: BenQ 1080P 24-Inch Monitor
amzn.to/2Usen2T
Webcam: Logitech C920 HD Webcam 1080P
amzn.to/3kz7Ca3
LED Studio Lights: x2 Neewar 660 LED Video Lights with Barn Doors, Stand, Bag and Dimmer
amzn.to/3f3tuJr
Camera Tripod: Manfrotto Advanced Tripod 3-Way Head with Quick Release
amzn.to/3pvmg5V

Опубликовано:

 

17 янв 2019

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 69   
@pickyphysicsstudent201
@pickyphysicsstudent201 4 года назад
You saved me like 180 minutes of work and tinkering, thank you!
@materialsandtechnology8956
@materialsandtechnology8956 4 месяца назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uNsVW9HWoC4.html
@iatsak167
@iatsak167 4 года назад
I was searching for something like this through many useless youtube videos, this is so easy and amazing, thanks!
@broderp
@broderp 3 года назад
Only works if data is the same type. (numbers in this case) How do you combine two graphs if one data set is a general number and the other is a percentage? Doing this method just gives a flat line at the bottom representing percentages. How do you do that?
@alvinyang5048
@alvinyang5048 3 года назад
Thank you so much for sharing this!
@jeanettesefers8180
@jeanettesefers8180 10 месяцев назад
That was so cool and easy.. Thanks for sharing.
@matthijsvandam7411
@matthijsvandam7411 3 года назад
You are the hero of my Master thesis thank you so much
@zaidized2912
@zaidized2912 3 года назад
Thank you so much sir!
@fun_timez_uk
@fun_timez_uk 2 года назад
Brilliant thanks! That was so easy I’m glad we saw this !
@jellymaneducation6168
@jellymaneducation6168 2 года назад
Hi Fun Timez UK, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy. jellyman-education.thinkific.com/courses/getting-started-with-tableau
@possiblyletty
@possiblyletty 3 года назад
I've just spent a whole 2 hours tinkering with this - you're a legend - thank you!
@jellymaneducation6168
@jellymaneducation6168 3 года назад
Hahaha!! Awesome!!!
@kal-el3644
@kal-el3644 3 года назад
Thank you so much for sharing this man. I was literally just about to leave the project in frustration, due to the time-consuming process of data selection. Just at the right time!
@jellymaneducation6168
@jellymaneducation6168 3 года назад
Thats awesome. Whats the project?
@kal-el3644
@kal-el3644 3 года назад
@@jellymaneducation6168 I’m doing an important presentation for my college and I needed to somehow combine data and therefore make one graph out of 6 different graphs. It ended up great and thanks to your video I didn’t have to waste much time on the matter:)
@marcandre6740
@marcandre6740 3 месяца назад
SUPER LIKE! YOU SAVED MY ASSIGNMENT
@chiarafritzler5500
@chiarafritzler5500 3 года назад
OH MY GOODNESS WHERE HAVE YOU BEEN. Thank you so much, I have been spending so much unnecessary time doing it with the "add data" function!
@jellymaneducation6168
@jellymaneducation6168 3 года назад
Hahahahaha you just described my whole tableau experience lols. Personally after all these years I still pick up a few tricks from time to time
@ubaidullah-pj9mu
@ubaidullah-pj9mu 3 года назад
the longest copy paste tutorial i've seen lmao!! much appreciated tho!
@zackvizeman5329
@zackvizeman5329 3 года назад
Outstanding trick; your friend and you are generous! Thanks very much!
@materialsandtechnology8956
@materialsandtechnology8956 4 месяца назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uNsVW9HWoC4.html
@namHin22815
@namHin22815 10 месяцев назад
WOW! WOW! WOW. Thanks a ton
@edric9911
@edric9911 3 года назад
thank you very much!!
@dcariello15
@dcariello15 3 года назад
Great video! But I have a question: how do you add the two Y-axis on both the left and right AND also add the y-axis labels?
@fotomakr
@fotomakr Год назад
🤯 likewise, always something new to learn.
@Rodriguito123456
@Rodriguito123456 4 года назад
I tried this with two boxplot graphs in excel 2013 and the values of the pasted boxplot where modified in the final graph. How can I correct this?
@glob567
@glob567 3 года назад
Thank you
@RobertCone
@RobertCone 3 года назад
Subscribed just because of this video, let's see what other tricks there are that two hours of googling doesn't bring up that maybe you will!
@camlocarter5842
@camlocarter5842 2 года назад
Thank you, you saved me hours
@harati6744
@harati6744 2 года назад
Super!! Thank you for sharing!
@jellymaneducation6168
@jellymaneducation6168 2 года назад
Hi, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy. jellyman-education.thinkific.com/courses/getting-started-with-tableau
@mariabdugarte7175
@mariabdugarte7175 3 года назад
Thank you! that is super helpful
@jellymaneducation6168
@jellymaneducation6168 3 года назад
Thanks Maria :)
@abynit
@abynit 3 года назад
How to do this if x-axis of second plot is also different.
@ghostfreak9137
@ghostfreak9137 Год назад
Thanks for this video it helped me prepare superimposed graph for the master curriculum 🙂
@jellymaneducation6168
@jellymaneducation6168 Год назад
That's awesome Ghostfreak!
@pagej4
@pagej4 2 года назад
you just saved me so much time. thank you!
@jellymaneducation6168
@jellymaneducation6168 2 года назад
Hi Jeremy, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy. jellyman-education.thinkific.com/courses/getting-started-with-tableau
@PURNAMILIND
@PURNAMILIND 2 года назад
You are a life saver.. Thank you
@materialsandtechnology8956
@materialsandtechnology8956 4 месяца назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uNsVW9HWoC4.html
@aditigurung4713
@aditigurung4713 Год назад
YOU SAVED ME THANK YOU 😭🤝🤝
@monyetguru
@monyetguru 3 года назад
THANK YOU!!
@jellymaneducation6168
@jellymaneducation6168 3 года назад
Thanks Dhiar
@sureshimmadi8236
@sureshimmadi8236 Год назад
What is one column of values are in number format and values in another column are in percentage format?? Please reply. Thanks
@aaryanbudhiraja1656
@aaryanbudhiraja1656 3 года назад
Thanks a lot
@jellymaneducation6168
@jellymaneducation6168 3 года назад
Thanks Aaryan!!!!!!!!!!!!!! :) :) :) :)
@fredwooten14
@fredwooten14 2 года назад
Udemy & youtube fantastic!!
@jellymaneducation6168
@jellymaneducation6168 2 года назад
Thanks Freddie! Btw, I have a FREE Tableau course now available on my website if you're interested! jellyman-education.thinkific.com/courses/getting-started-with-tableau
@jasondmaguire
@jasondmaguire 3 месяца назад
I cant seem to get this to work. Im trying to over lay consultations per month with revenue per month. no matter what it always shows back up with one line. please help!!!!
@GauravKumawat26
@GauravKumawat26 Год назад
Like really duuudeee !!! 😱😱😱😱😱
@mjs1592
@mjs1592 3 года назад
Thank you, I got tired trying figure it out
@_dMb_dMb
@_dMb_dMb Год назад
hell that works
@DanBurgaud
@DanBurgaud Год назад
0:50 I have a very big (13000 lines) data; selecting this way isnt practical for me. Any way of selecting it?
@dinosaurtimesten
@dinosaurtimesten 3 года назад
Damn bro, if only I had known this in college.
@martina71704
@martina71704 2 года назад
Hi, I couldn't make it work for two bar graphs!
@agwujerome6084
@agwujerome6084 Год назад
God bless you😭
@marians8048
@marians8048 2 года назад
Sa-ti dea Dumnezeu sanatate.
@jellymaneducation6168
@jellymaneducation6168 2 года назад
Hi Marian, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy. jellyman-education.thinkific.com/courses/getting-started-with-tableau
@mythilisamyuktha8898
@mythilisamyuktha8898 Год назад
Could you please show me the pyramid graphs?
@adhip0574
@adhip0574 Год назад
HOW DO YOU GIVE THEM DIFFERENT AXIS!!!!!!!
@erfanzandi1338
@erfanzandi1338 2 года назад
cool!
@jellymaneducation6168
@jellymaneducation6168 2 года назад
Hi Erfan, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy. jellyman-education.thinkific.com/courses/getting-started-with-tableau
@alansari1985
@alansari1985 11 месяцев назад
Doesn't worl with box plots
@hamadhassan480
@hamadhassan480 2 года назад
Back me my two minutes which are wasted watching this
@truth517
@truth517 3 года назад
Doesn’t work on mines
@Tommuli_Haudankaivaja
@Tommuli_Haudankaivaja Год назад
Unfortunatelly, it would seem that doing this crashes my Excel. I'll just have to tell my boss that no can do. 5 million data points are too much.
@shivaputrakrishna9719
@shivaputrakrishna9719 Год назад
This guy has hacked excel!
@bahaablast5525
@bahaablast5525 Год назад
-40% for not including Legends and not showing me how to transfer over legends
@GeckoForReal
@GeckoForReal 2 года назад
Thanks, but you could have just skipped the first 1 min 30 s of the video. Because how to create a graph is not the topic :).
Далее
Weekly Sales chart in Excel
10:34
Просмотров 396 тыс.
Build 5 ADVANCED Excel Charts from Scratch
14:14
Просмотров 209 тыс.
Graphing two data sets on the same graph with Excel
6:10
Excel Combo Chart: How to Add a Secondary Axis
10:08
Просмотров 258 тыс.
Make Impressive McKinsey Visuals in Excel!
16:47
Просмотров 282 тыс.
Two data sets Combine into Single Chart - MS Excel
9:48
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
Plot Multiple Lines in Excel
1:57
Просмотров 1,3 млн