How to Create Multi-Color Scatter Plot Chart in Excel

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:


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******

******More Videos in Playlists******

#ExcelforHR#HRAnalytics#Excel#HR

[emilytran]

Thank you ! Very simple and clear instructions.

[charlottebbq]

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

[eliasbrookin]

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

[fabiopalermo]

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

[marcostnf]

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

[glatisant]

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

[RenatoT-sivv]

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

[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

[ElizabethForrest-ivhj]

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)

[anna-caefuller]

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

[nicolegavigan]

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

[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

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

[parimipragna]

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

[sayyidal-bahr]

Thank you.. its very helpful explaination

[lucyharris]

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

[pavlos]

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.

[karinalopezhuitron]

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!

[ameenfayad]

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.

[szabolcshatala]

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