How to Create Multi-Color Scatter Plot Chart in Excel

Просмотров 69 тыс.

% 401

Want to learn how to design a salary structure? Check: www.caripros.com/design-salary-structure-with-regression-analysis-upgraded-with-case-study
FREE template for my video: Excel for HR - Create Annual Employee Salary Increase Template from Scratch. You can download and try it out yourself here: bit.ly/2MLLdb7
FREE actual workbook for my video "Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner". You can download and try it out yourself here: bit.ly/2UmeX2v
New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:
caripros-hr-analytics.teachab...
Topic: How to create a multi-color scatter plot chart in Excel
Business Scenario: You need to show pay compression issue by performance rating category
Formula: Scatter Chart
******Follow-up Consulting Services******
If you have specific question regarding your issue, you can email me at the email here goo.gl/WejijZ
Note that there will be a fee of US$200 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link: www.paypal.me/caripros
******More Videos in Playlists******
Power BI for Beginners: bit.ly/3ivKitD
Power BI for Advanced Users: bit.ly/3lE9zmO
Excel for HR goo.gl/JdeVnd
Excel for HR - Master Class goo.gl/LYfq2f
Excel Macro - Beginner goo.gl/Yae5nc
Excel Macro/VBA - Splitting a Master File goo.gl/m8CHya
Excel Macro/VBA - Auto-hide Rows or Columns bit.ly/2Mzteb5
Excel Charts Data Visualization goo.gl/2ao6BP
Excel Vlookup Function goo.gl/kP2Wpz
Excel Pivot Table Function goo.gl/rukkPs
Excel Array Function goo.gl/i4sQH8
Excel Index and Match Function goo.gl/i7VGU4
Excel Solver/Goal Seek Functions goo.gl/FTkTnj
Excel Cell Formatting Solutions goo.gl/gpa6MY
HR Analytics - Merit Matrix goo.gl/Koy7co
HR Analytics - Salary Structure goo.gl/uZBnFa
Excel Tricks goo.gl/TeqGDw
Excel Troubleshooting goo.gl/bdY5by
Fun HR Topics goo.gl/7zVg8h
For more successful stories, view at: caripros.com/index.php/success...
#ExcelforHR#HRAnalytics#Excel#HR

Хобби

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

3 май 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 37

@emilytran84 24 дня назад

Thank you ! Very simple and clear instructions.

@user-bd1xe5jr7d 29 дней назад

Thank you, it was very helpful!

@eliasbrookin5673 Год назад

Hero! Took me all day of watching tutorials with my test in less than half an hour to finally find out how to do it! Thank you

@xsparkee 28 дней назад

Wow! Thank you very much!

@nicolegavigan5685 2 года назад

This was exactly what I needed to know, thank you so much!

@RenatoT-si7vv Год назад

Thanks a lot, I was about to replicate the same chart 3 times to have this effect.

@dhapked 2 года назад

Perfect!! I was looking for JUST this!! Easy and concise. By any chance, can you show how to reduce the clusters (dots) if you have TOO many values that is congesting the chart?

@Kaths_bucket_list 3 года назад

I really appreciate your prompt reply. Your chart is really very helpful and very impressive, Hope to see more similar analysis charts from you, Lots of hugs from Singapore

@anna-caefuller7724 Год назад

Super helpful and concise video. Perfectly conveyed what I needed to know.

@Rationalw Год назад

Thanks a lot! This was sooooo helpful!!!!

@yannikwohnsdorf8944 Год назад

Thanks - that was really helpful!

@marcostnf 8 месяцев назад

Wonderful, thank you for providing such a concise and useful explanation!

@ismailguler5722 2 месяца назад

Great solution, Tnx.

@amith464 7 месяцев назад

this is the best!

@sayyidal-bahr8235 4 месяца назад

Thank you.. its very helpful explaination

@littledude52 Год назад

Thank you

@glatisant74 8 месяцев назад

easier if you rearrange your data: 1st column : tenure in job (X axis) 2nd column: salary for grade A employees (Y axis series 1: shows salary if grade is A, otherwise 0, you do it with an if) 3rd column: salary for grade B employees (Y axis series 2: shows salary if grade is B, otherwise 0, you do it with an if) 4th column: salary for grade C employees (Y axis series 3: shows salary if grade is C, otherwise 0, you do it with an if) then you select all 4 columns (including header) and throw a scatterplot on it. The scatterplot will interpret the leftmost column as X axis variable, and all the other 3 as different series for Y, all 3 will automatically receive different colors

@agagaga007 6 месяцев назад

Very helpful, thanks for sharing this tip!

@fabiopalermo1688 3 года назад

Hi dear, I have very appreciate your video. I have crated the same plot but in this way the graph will change by changing the order of the table. I would like to know if there is a method to create a similar plot but avoiding the problem od changing order of the table. Please, can you share any suggestion? Many thanks

@sudarkartheepan 14 дней назад

what if i need to do this for a really large number of values, is there a shortcut or macro or something that I can use

@ElizabethForrest-iv7hj 2 месяца назад

Hello :) I'm wondering if you can show us how to add a horizontal line for the average for each of the colour groups (for example y = 0.2 for the 'new' tenure category in your video)

@parimipragna1876 2 года назад

I have to add a trend line for all the points together. How can I do that?

@lucyharris7708 2 года назад

Hello, this is a great help but I noticed when two salaries are the same it only shows them in one colour, is there any way to correct this so that I can see both Colours? I’m trying to show male/female outliers in salary data but the males colour are showing only when the two salaries are the same for both male and female. Thanks

@karinalopezhuitron6003 2 года назад

Hello, I hope you are well. I am writing to you because I have a question. I would like to know how I can color by 8 categories, instead of the 3 I currently have, in this data. Manually I am adding series by series, but if my NCM values change, the cells would no longer correspond to the country. Is there any way to set an IF function at the time of making the graph, in the part of X and Y values? Thanks!

@pavlos1016 Год назад

What if I want to include the job name (if such a thing existed in the data) to show up when I hover the dots.

@Kaths_bucket_list 3 года назад

By the way, I am wondering if you could share with us if you have done any presentation, includes all the useful charts in one single PPT. It is simply too many useful charts and I don’t know how to start 😂 and how to make it simple and persuasive. I mean, those charts / dash board are useful for us to dig deeper, but if we prepare presentations to senior management, I don’t think they want to see those dots and numbers..... Do share with us 👍👍👍

@CariprosHRAnalytics 3 года назад

Hi Katharina - i do have a playlist focusing on visualization which you can check out Excel Charts Data Visualization goo.gl/2ao6BP I don't really possess the charts that I did for my clients in the past, but yes you are right there are definitely more things i can share on how to present good visuals to senior mgmt. I can definitely make videos on this topic in the future. =)

@szabolcshatala9729 Год назад

This is cool but SPSS can do all of this in about 10 clicks and its more useful for larger data sets

@CariprosHRAnalytics Год назад

100%, but keep in mind not all has access to SPSS, and not all has the time to invest in learning a new tool. Also not all needs to solve this problem for a large data set. I try to help people by enabling them to solve their problems with the most feasible way in the shortest time possible, so that their time can be better spent elsewhere in their life. 😀

@ameenfayad633 3 года назад

Hi , first of all i would to thank you for your precious time 🙏. i have a problem i wish you can help me to solve it. My problem with the size of the font of data validation list , i am using macron to hide some rows depending in the value of the cell of the data validation list. I tried to linked combo box to the cell of data validation list but macrons didn't work . I would be thankfull if you can shot a video about this problem.

@CariprosHRAnalytics 3 года назад

hi Ameen - is there a reason that you can't change the font size in the cell directly?

@ameenfayad633 3 года назад

@@CariprosHRAnalytics i cant change data validation list font