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.