Forum Discussion
shannong525
Nov 24, 2019Copper Contributor
I have a really simple graph question
Hello! I'm pulling an all-nighter finishing this research paper and I CANNOT figure out how to get this graph how I want it. It's super simple, just comparing the voter turnout and the # of days from...
SergeiBaklan
Nov 24, 2019Diamond Contributor
That's since your X-axis data is not top left column, Excel assumes on X are States. To adjust
- right click your Chart and Select Data
- here ignore X, remove first series, and edit second one
- select proper X and Y for the series
Result is like this
- click on Change Chart Type and select Scatter with lines
The rest is just cosmetic: