Question description:
This user has given permission to use the problem statement for this
blog.
I can't figure out how to insert a graph in Excel Online - It's treating each column as it's own set of y-values.
Solved by E. H. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
28/09/2018 - 12:23
Welcome to ExcelChat!
User
28/09/2018 - 12:23
Hi! Just to clear things up from the start, I'm using Excel Online, since I'm on a macbook, not normal microsoft excel.
Excelchat Expert
28/09/2018 - 12:24
ok
Excelchat Expert
28/09/2018 - 12:24
Got it!
Excelchat Expert
28/09/2018 - 12:24
Do you have the data
Excelchat Expert
28/09/2018 - 12:25
I will do it with you in Excel online to see what is the issue
User
28/09/2018 - 12:25
[Uploaded an Excel file]
User
28/09/2018 - 12:25
That's what's happening
User
28/09/2018 - 12:25
It treats the columns as their own y-values
Excelchat Expert
28/09/2018 - 12:26
Got it! What kind of chart did chosse?
User
28/09/2018 - 12:26
And I don't see a format tab either
User
28/09/2018 - 12:26
Line
Excelchat Expert
28/09/2018 - 12:26
I think this is the issue
User
28/09/2018 - 12:26
What graph should I use?
Excelchat Expert
28/09/2018 - 12:26
You need Scatter chart
User
28/09/2018 - 12:26
When I use scatter, I can't find a way to connect the points
Excelchat Expert
28/09/2018 - 12:27
OK
User
28/09/2018 - 12:27
Oh my god I'm stupid, I tried a different type of scatter chart and it worked
User
28/09/2018 - 12:27
Sorry, I figured it out
Excelchat Expert
28/09/2018 - 12:27
Good work!
User
28/09/2018 - 12:27
Thank you for pointing that out, I would have been running in circles
Excelchat Expert
28/09/2018 - 12:28
You got it!
Excelchat Expert
28/09/2018 - 12:28
Do you have any other question regarding this session?
User
28/09/2018 - 12:28
Nope that was all
User
28/09/2018 - 12:28
Have a great night!
Excelchat Expert
28/09/2018 - 12:28
You too, Thank you!
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.
