**Question description:**

*This user has given permission to use the problem statement for this blog.*

Help with making a combo chart (scatter and column) with multiple series

Solved by Z. Y. in 19 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
06/08/2017 - 05:33

“Welcome, Thanks for choosing Got It Pro-Excel”

Excelchat Expert
06/08/2017 - 05:34

Hello! Are you there?

User
06/08/2017 - 05:35

Hello

User
06/08/2017 - 05:35

I need help making a graph like this:

Excelchat Expert
06/08/2017 - 05:35

“How may I help you today?”

User
06/08/2017 - 05:36

I want to make a combo chart

User
06/08/2017 - 05:36

With column and scatter

User
06/08/2017 - 05:36

For the columns I want them to represent a whole average

User
06/08/2017 - 05:36

so I have three columns and they will represent three averages

User
06/08/2017 - 05:36

I then have 7 people with data for each column

User
06/08/2017 - 05:36

i want that to be a scatter

Excelchat Expert
06/08/2017 - 05:37

please add some data so that I can help you better

User
06/08/2017 - 05:37

do i should have 7 dots for each column

User
06/08/2017 - 05:37

Is this all confidential?

Excelchat Expert
06/08/2017 - 05:37

Yes

User
06/08/2017 - 05:39

:)

User
06/08/2017 - 05:39

sorry for the delay

Excelchat Expert
06/08/2017 - 05:40

It's ok.

Excelchat Expert
06/08/2017 - 05:40

where is the data file?

Excelchat Expert
06/08/2017 - 05:40

Upload it here

User
06/08/2017 - 05:40

I dont have one

User
06/08/2017 - 05:40

I have copied the numbers into excel

Excelchat Expert
06/08/2017 - 05:40

I can't see any numbers

User
06/08/2017 - 05:41

actually do not worry

User
06/08/2017 - 05:41

I will try to do it

Excelchat Expert
06/08/2017 - 05:42

I got it, can see now

User
06/08/2017 - 05:42

It is ok

User
06/08/2017 - 05:42

do I have to pay?

Excelchat Expert
06/08/2017 - 05:42

I will share a video that will help you

Excelchat Expert
06/08/2017 - 05:42

https://youtu.be/39fWIp70olQ

User
06/08/2017 - 05:42

Thank you :)

Excelchat Expert
06/08/2017 - 05:42

This gives details about generating combo charts

User
06/08/2017 - 05:43

I have seen this video :)

User
06/08/2017 - 05:43

But I am trying to do something slightly different

Excelchat Expert
06/08/2017 - 05:43

Ohh, tell me

User
06/08/2017 - 05:43

I am trying to get my average values as 3 columns and then everything else as dots that should be for each column

Excelchat Expert
06/08/2017 - 05:43

I will help you

User
06/08/2017 - 05:44

I am just worried because I cannot pay

User
06/08/2017 - 05:44

but i appreicate your time anyway :)

Excelchat Expert
06/08/2017 - 05:44

first session for users is free :)

User
06/08/2017 - 05:44

ok so this is my first session :)

Excelchat Expert
06/08/2017 - 05:44

fine

Excelchat Expert
06/08/2017 - 05:45

but I am not getting this portion:

Excelchat Expert
06/08/2017 - 05:45

get my average values as 3 columns

Excelchat Expert
06/08/2017 - 05:45

please elaborate

User
06/08/2017 - 05:45

so

User
06/08/2017 - 05:45

the ones i have highlighted

User
06/08/2017 - 05:45

the overall averages for X Y Z

User
06/08/2017 - 05:45

they need to be three columns

User
06/08/2017 - 05:45

so a normal column

User
06/08/2017 - 05:45

chart

User
06/08/2017 - 05:46

and then these will be individual dots

User
06/08/2017 - 05:46

like this

Excelchat Expert
06/08/2017 - 05:47

Ok, please wait

User
06/08/2017 - 05:47

ok

User
06/08/2017 - 05:51

My session is about to expire! :) I appreciate your time anyway

Excelchat Expert
06/08/2017 - 05:52

https://docs.google.com/spreadsheets/d/1VW7pOLT09gtEpGXSWr02H2Y-W8HrQ6TJUfVE5jV8IfE/edit?usp=sharing

Excelchat Expert
06/08/2017 - 05:52

Please open above link, we will continue there

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*