How to Create Double Clustered Column Chart with Scatter Points

[@dvdplayer128]

5:50 until 9:35 I would deem the useful snippet. Thanks!

[@Matti1600]

Super helpful, I really appreciate you taking the extra time to pull this video together

[@laxmanegalitarian8581]

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]

Wow, it was really easy to follow. Thank you so much for this!!!

[@gabbymctin]

Thank you for making the video!!!

[@mikeh6208]

Another great tip! Keep it up.

[@alexescott6443]

Is there a way to replicate this in PBI? Management loves this graph and having difficulty replicating in PBI

[@chchutima210]

Thank you very much for sharing.

[@irenehu1734]

我真的没看懂。。。 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]

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]

It may have to do with your version of Excel. You may not be able to do this with Excel 2010 or below.

[@guamhonu]

How would you do it with three or more job families? How do you do the spacing for the scatter points?

[@CariprosHRAnalytics]

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]

thank you !!!

[@chrisr7399]

you're my hero

[@CariprosHRAnalytics]

Thank you!

[@zhiqianghuang4045]

I found my problem. I had to use numbers for x axis, such as 1, 2, 3, 4 etc.

[@klrdto3250]

What were using before?