How to Create Multi-Color Scatter Plot Chart in Excel

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

[@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

[@fabiopalermo1688]

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

[@emilytran84]

Thank you ! Very simple and clear instructions.

[@ElizabethForrest-iv7hj]

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)

[@dhapked]

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?

[@RenatoT-si7vv]

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

[@Kaths_bucket_list]

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

[@marcostnf]

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

[@sudarkartheepan]

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

[@anna-caefuller7724]

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

[@ilirian2000]

Thank you, it was very helpful!

[@glatisant74]

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]

Very helpful, thanks for sharing this tip!

[@charlottebbq0321]

This is what I want~It helps my work a lot! Thanks!

[@parimipragna1876]

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

[@nicolegavigan5685]

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

[@sayyidal-bahr8235]

Thank you.. its very helpful explaination

[@yannikwohnsdorf8944]

Thanks - that was really helpful!

[@Rationalw]

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

[@xsparkee]

Wow! Thank you very much!

[@lucyharris7708]

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

[@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.

[@ismailguler5722]

Great solution, Tnx.

[@ph3124wr]

Thank your very much.

[@ameenfayad633]

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]

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

[@ameenfayad633]

@@CariprosHRAnalytics i cant change data validation list font

[@karinalopezhuitron6003]

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!

[@amith464]

this is the best!

[@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. 😀

[@Kaths_bucket_list]

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]

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. =)

[@littledude52]

Thank you

[@SolidSnake59]

This is so NOT dynamic.

[@jasonrubik]

Can you please give us a demo of the dynamic method ?

[@PK-hr7xo]

No you don't show or explain how the color come about.

[@NoName-zi9qs]

That is so bloated.