# Excel - COLUMN Function Problem - Expert Solution

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
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
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
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
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
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
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
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
Excelchat Expert 06/08/2017 - 05:52

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.