Тёмный

Create Quadrant Lines for an XY Scatter Chart 

Doug H
Подписаться 78 тыс.
Просмотров 95 тыс.
50% 1

This video shows how to create a four quadrant matrix and mark them for an XY scatter chart. Sure you can use the drawing tool to make the lines that'll make up your 4 quadrant areas, but what fun would that be? Let's use a table of data to create the quadrant so you can model your data more visually.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

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

 

20 авг 2016

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 41   
@r3dLands
@r3dLands 6 лет назад
you're the best man, straight to the point and I understood everything
@DougHExcel
@DougHExcel 6 лет назад
Hi r3dLands, thanks for the comment!
@KevinJarrett
@KevinJarrett 6 лет назад
Super helpful, easy to understand, thanks so much! Awesome job!
@DougHExcel
@DougHExcel 6 лет назад
+Kevin Jarrett Thanks for the comment!
@alexrosen8762
@alexrosen8762 7 лет назад
Very useful and informative. Thanks Doug :-)
@DougHExcel
@DougHExcel 7 лет назад
Hi Alex Rosén...you're welcome, glad you liked! Thanks for watching
@abdulquddusbayuko5062
@abdulquddusbayuko5062 7 лет назад
Gracias. Thanks for the education. Very useful.
@DougHExcel
@DougHExcel 7 лет назад
Hi Abdulquddus Bayuko...you're welcome, glad you liked!
@niklasvonderwarth4725
@niklasvonderwarth4725 7 лет назад
Thanks! Great Video...You helped me a lot.
@DougHExcel
@DougHExcel 7 лет назад
Thanks Niklas von der Warth, glad it helped!
@shizubk1532
@shizubk1532 7 лет назад
Thanks ..very well explained :)
@DougHExcel
@DougHExcel 7 лет назад
You're welcome, thanks for the comment!
@theresaolusola86
@theresaolusola86 7 лет назад
Thank you, very helpful video
@DougHExcel
@DougHExcel 7 лет назад
You're Welcome!
@erickeizer493
@erickeizer493 5 лет назад
Great tutorial, thanks!
@DougHExcel
@DougHExcel 5 лет назад
You’re welcome!
@anatolimaximus9438
@anatolimaximus9438 6 лет назад
Very useful thank you
@DougHExcel
@DougHExcel 6 лет назад
You're Welcome!
@spatnik
@spatnik 3 года назад
Super helpful. Saves me the irritation of using manual lines!
@DougHExcel
@DougHExcel 3 года назад
Great to hear!
@michaelgowlett5036
@michaelgowlett5036 7 лет назад
cheers doug nice!
@DougHExcel
@DougHExcel 3 года назад
Hi Michael Gowlett, thanks for the comment!
@SyedSabihNadeem__
@SyedSabihNadeem__ 2 года назад
Thank you very much
@DougHExcel
@DougHExcel 2 года назад
You are welcome
@immanuelsuleiman7550
@immanuelsuleiman7550 4 года назад
excellent thank you very much
@DougHExcel
@DougHExcel 4 года назад
You are welcome!
@immanuelsuleiman7550
@immanuelsuleiman7550 4 года назад
@@DougHExcel keep up the good work
@AbdurRahman-xo1fk
@AbdurRahman-xo1fk 5 лет назад
Nice
@DougHExcel
@DougHExcel 5 лет назад
Hi Abdur Rahman, thanks for the comment!
@topalecom
@topalecom 5 лет назад
How do we create a Scattered chart pulled from a datasheet with 4 categorie? instead of randomly creating numbers. any idea ? My Excel sheet is connected to sharepoint so the data will be changing from time to time and I cant the chart to run off the datasheet ... is that possible ?
@DougHExcel
@DougHExcel 5 лет назад
maybe these video will give some insight ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hCAbxtkZoVg.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6ekd_j0G0b0.html
@drumvannelle69
@drumvannelle69 4 года назад
Great video, can you do similar one for bubble chart? Or it will not work???
@DougHExcel
@DougHExcel 4 года назад
I haven't tried for bubble chart, but the concepts should not be too different
@drumvannelle69
@drumvannelle69 4 года назад
Doug H I tried it on bubble charts but it does not allow to add any line so I had to resort to VBA via a macro and it works like a charm. Thank you for the inspiration
@DougHExcel
@DougHExcel 4 года назад
Hi Sherif Ali, thanks for adding to the thread!
@gastonarce
@gastonarce 2 года назад
How do i put names to every point?
@M7amadhaifa
@M7amadhaifa 8 лет назад
is there a way to make it more dynamic
@brianxyz
@brianxyz 8 лет назад
I was thinking the same thing. Maybe something like (Max(range)-Min(range))/2 would be best.
@M7amadhaifa
@M7amadhaifa 8 лет назад
+brianxyz or using macros n adding to it min max n avg
@DougHExcel
@DougHExcel 8 лет назад
How Excel determines axis limits is a mystery that would give some challenge to MAX/MIN formula. See Jon Peltier's post on this peltiertech.com/how-excel-calculates-automatic-chart-axis-limits/ However he does have a "solution" via VBA that might help with this question. peltiertech.com/link-excel-chart-axis-scale-to-values-in-cells/
@M7amadhaifa
@M7amadhaifa 7 лет назад
+Doug H thanks a lot will have a look at it
Далее
Add Multiple Series of Data to X Y Scatter Chart
5:11
Create a Basic Control Chart
9:55
Просмотров 548 тыс.
Дарю Самокат Скейтеру !
00:42
Просмотров 1,9 млн
🎙ПЕСНИ ВЖИВУЮ от КВАШЕНОЙ🌹
3:09:38
How to Make a Scatter Plot in Excel
4:42
Просмотров 279 тыс.
Create an X Y Scatter Chart with Data Labels
7:23
Просмотров 453 тыс.
Create an XY Scatter Chart in Excel
7:23
Просмотров 43 тыс.
Create a BCG Matrix
11:55
Просмотров 396 тыс.
Дарю Самокат Скейтеру !
00:42
Просмотров 1,9 млн