I'm trying to figure out if I can graph this and if so how, because so far I can't figure it out....
In my excel file I have a list of coordinates X:Y in one column, which go from 0-600.
For example:
368:274
369:274
424:280
244:280
41:327
49:6
476:308
6:14
Its all in one column as X-value:Y-value, so x-value is 368, y-value is 274.
I want to take these coordinates and graph them like a map kinda. I really don't want to go through and separate these into two columns since its A LOT of data I have. Is there a way to tell excel that in that column its X:Y. like an option when making graph, or a formula or something? Is there a way to graph this and how? Thanks!
In my excel file I have a list of coordinates X:Y in one column, which go from 0-600.
For example:
368:274
369:274
424:280
244:280
41:327
49:6
476:308
6:14
Its all in one column as X-value:Y-value, so x-value is 368, y-value is 274.
I want to take these coordinates and graph them like a map kinda. I really don't want to go through and separate these into two columns since its A LOT of data I have. Is there a way to tell excel that in that column its X:Y. like an option when making graph, or a formula or something? Is there a way to graph this and how? Thanks!