Jan 20 2017
08:40 PM
- last edited on
Jul 25 2018
09:36 AM
by
TechCommunityAP
Jan 20 2017
08:40 PM
- last edited on
Jul 25 2018
09:36 AM
by
TechCommunityAP
I am a complete newbie and I have been looking up resources to help me create a simple line graph. I have tried Excel exposure, various videos, and yet those didn't help with the problem I am having.
Everytime I highlight the two columns, it puts both of them in one axis. I can't seem to fix this. Any advice would be much appreicated. I am trying to make column A the x-axis and column B the y-axis.
File attached in text document. I can't seem to upload the actual Excel file to the browse tab.
Jan 21 2017 01:57 AM - edited Jan 21 2017 01:58 AM
Hello,
a Scatter Chart (XY-Chart) can display your values on the X and Y-Axes. I attached a sample file with two sample scatter charts (variations) in it. This article Present your data in a scatter chart or a line chart explains the differences between a line and scatter chart.
Best,
Mourad
Jan 21 2017 04:45 PM
Thanks, I have read the article and looked at your graph. I can't figure out how did you seperate the data into column A and column B. When I extract the text file into excel, it all goes into one column.
Jan 21 2017 11:17 PM
SolutionHello,
I used the legacy text file import assistant for getting the data into the Excel sheet. The steps...
Best,
Mourad
Jan 21 2017 11:17 PM
SolutionHello,
I used the legacy text file import assistant for getting the data into the Excel sheet. The steps...
Best,
Mourad