How to Create Double Clustered Column Chart with Scatter Points

  Рет қаралды 35,182

Caripros HR Analytics

Caripros HR Analytics

Күн бұрын

Пікірлер: 20
@dvdplayer128
@dvdplayer128 4 жыл бұрын
5:50 until 9:35 I would deem the useful snippet. Thanks!
@Matti1600
@Matti1600 4 жыл бұрын
Super helpful, I really appreciate you taking the extra time to pull this video together
@laxmanegalitarian8581
@laxmanegalitarian8581 2 жыл бұрын
Hi, thank you very much for such informative content. This is exactly what I was looking for but I still have a small question if you could answer. Can we also do this if the x-axis is not numbers but items? What I am trying to do is make double clustered columns of the averages of two quantities on different trials of an experiment and also want to scatter plot the points of which the averages are the column charts, if this makes sense.
@emim7638
@emim7638 4 жыл бұрын
Wow, it was really easy to follow. Thank you so much for this!!!
@gabbymctin
@gabbymctin 3 жыл бұрын
Thank you for making the video!!!
@mikeh6208
@mikeh6208 5 жыл бұрын
Another great tip! Keep it up.
@alexescott6443
@alexescott6443 6 ай бұрын
Is there a way to replicate this in PBI? Management loves this graph and having difficulty replicating in PBI
@chchutima210
@chchutima210 4 жыл бұрын
Thank you very much for sharing.
@irenehu1734
@irenehu1734 2 жыл бұрын
我真的没看懂。。。 for me when I select combo, it only shows the combination of bar and line, I don't have an option to choose scatter
@zhiqianghuang4045
@zhiqianghuang4045 3 жыл бұрын
That is very simple methods to follow. However, I was not able to line up the x axis of scatter plots and bar graph. It seems there was a secondary x axis existed but I was not able to find it and format it. Please help.
@CariprosHRAnalytics
@CariprosHRAnalytics 3 жыл бұрын
It may have to do with your version of Excel. You may not be able to do this with Excel 2010 or below.
@guamhonu
@guamhonu 3 жыл бұрын
How would you do it with three or more job families? How do you do the spacing for the scatter points?
@CariprosHRAnalytics
@CariprosHRAnalytics 3 жыл бұрын
yea you can do it with more columns, but for the spacing of the points, i think u can do it only by adjusting your y-axis range
@silviarmp
@silviarmp 3 жыл бұрын
thank you !!!
@chrisr7399
@chrisr7399 5 жыл бұрын
you're my hero
@CariprosHRAnalytics
@CariprosHRAnalytics 5 жыл бұрын
Thank you!
@zhiqianghuang4045
@zhiqianghuang4045 3 жыл бұрын
I found my problem. I had to use numbers for x axis, such as 1, 2, 3, 4 etc.
@klrdto3250
@klrdto3250 Жыл бұрын
What were using before?
Bar chart with differences in Excel
13:49
RBX Excel videos
Рет қаралды 158 М.
Excel for HR - What is Compa-Ratio and How to Calculate it
7:47
Caripros HR Analytics
Рет қаралды 26 М.
ПРЯМОЙ ЭФИР. Золотой мяч France Football 2024
4:41:06
Ouch.. 🤕⚽️
00:25
Celine Dept
Рет қаралды 29 МЛН
REAL 3D brush can draw grass Life Hack #shorts #lifehacks
00:42
MrMaximus
Рет қаралды 12 МЛН
MY HEIGHT vs MrBEAST CREW 🙈📏
00:22
Celine Dept
Рет қаралды 93 МЛН
How to Create a Merit Matrix for Salary Increase with Goal Seek Function
20:06
Caripros HR Analytics
Рет қаралды 47 М.
Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 1)
15:12
BEST CROISSANT IN PARIS
6:41
Luis
Рет қаралды 14 МЛН
Clustered Stacked Bar Chart In Excel
8:09
Pandi Mengri
Рет қаралды 621 М.
How to Make a Clustered Bar Chart with Target Dots in PowerPoint! [PPT TIPS!]
14:03
Spotlight Impact Data Design
Рет қаралды 2,9 М.
Excel Column Chart - Stacked and Clustered combination graph
11:05
Leila Gharani
Рет қаралды 539 М.
Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 2)
13:13
Publication Quality Bar Graph in Excel for Research
19:09
Vivo Phys - Evan Matthews
Рет қаралды 179 М.
ПРЯМОЙ ЭФИР. Золотой мяч France Football 2024
4:41:06