I'm using excel 2011 on my mac
I have a ton of data which can change at any time and on several worksheets.
I'm trying to map data onto a scatter plot and I would like to make a individual scatter plot for each person, a scatter plot for everyone on each worksheet but show each person as a different color and then if possible a scatter plot of all the worksheets with each worksheet being a different color.
Yes, I'm nerdy, but this is for a game. What i have is each worksheet is an alliance, then in that worksheet is the players name and different coordinates of their cities and all.... I want to make a scatter chart of each person, then make one of all the player in one alliance but have each player a different color (so each player is their own series i guess), and then make a map (scatter chart) of all the alliances with each alliance in a different color (so each alliance as their own series i think).
So here is what my data looks like...
A________________B__________C_________D_____________________F_______G
-SCORPION-___Lvl 16___________________________________
____________________________main____292:288______________292_______288
____________________________sub______292:286______________292_______286
____________________________sub____________________________
____________________________sub____________________________
____________________________sub____________________________
____________________________sub____________________________
____________________________fort_______292:287____________292_______287
LoveJockey__________________________________________
____________________________main_____254:9________________254_______9
____________________________sub_______255:8_______________255_______8
____________________________sub_______58:148______________58_______148
____________________________fort_______248:11______________248_______11
Wrathly__________________________________________
____________________________main______578:22______________578_______22
____________________________sub_______579:22______________579_______22
____________________________sub_______577:22______________577_______22
____________________________fort_______565:25______________565_______25
____________________________fort_______576:21______________576_______21
____________________________fort_______578:29______________578_______29
____________________________fort_______588:27______________588_______27
Calixleo__________________________________________
____________________________main______101:10______________101_______10
____________________________sub_______183:226______________183_______226
____________________________sub_______185:224______________185_______224
____________________________sub_______139:458______________139_______458
____________________________sub_______140:458______________140_______458
____________________________fort_______138:461______________138_______461
Eddyzila__________________________________________
____________________________main______23:283______________23_______283
____________________________sub_______23:282______________23_______282
____________________________sub_______23:284______________23_______284
____________________________sub_______19:282______________19_______282
____________________________sub_______26:292______________26_______292
Aredes75__________________________________________
____________________________main_____380:16______________380_______16
____________________________sub_______415:56______________415_______56
____________________________sub_______406:115_____________406_______115
____________________________sub_______352:8________________352_______8
____________________________fort_______399:7________________399_______7
____________________________fort_______406:45______________406_______45
____________________________fort_______352:21______________352_______21
Etc...
I had to add in _____ because it didn't want to space out my data and then you couldn't see the columns very well so ignore those
So Column A I have the players name
Column B isn't filled in all the way but will have their level that they are, for example -SCORPION- is lvl16. Their level tells us how many sub cities they can have... Everyone has one main city but for every 3 levels, they get another sub city. For example lvl 1 to 3 have 0 sub cities (just the main), lvl 4-6 have 1 sub city, 7-9 have 2 sub cities, lvl 10-12 have 3 sub cities, lvl 13-15 have 4 subs, lvl 16-18 have 5, etc. I guess ignore column B since its just so I can see how many subs they have unless you know a way to input that or something....
Column C is what it is, so main (city), sub (city), fort, oasis.
Column D is the coordinates so 292:288. I have it written like that so I can easily copy some of this data and send it to friends on game so that is why I have column F and G.....
Column E is just blank space to separate columns
Column F and G is Column D copied over and then I did "Data --> Text to Columns --> Delimited :" I did that so that I could make a chart of those numbers since before hand there are text. So 292:288 becomes x= 292 and y= 288.
I want scatter charts to have scale for x and y of 0-600. I want Y values in reverse order. I would like there to be major (and maybe minor) gridlines.
Please help.... I'm assuming I'm going to have to use macro.. but no idea what the code should be.....
I have a ton of data which can change at any time and on several worksheets.
I'm trying to map data onto a scatter plot and I would like to make a individual scatter plot for each person, a scatter plot for everyone on each worksheet but show each person as a different color and then if possible a scatter plot of all the worksheets with each worksheet being a different color.
Yes, I'm nerdy, but this is for a game. What i have is each worksheet is an alliance, then in that worksheet is the players name and different coordinates of their cities and all.... I want to make a scatter chart of each person, then make one of all the player in one alliance but have each player a different color (so each player is their own series i guess), and then make a map (scatter chart) of all the alliances with each alliance in a different color (so each alliance as their own series i think).
So here is what my data looks like...
A________________B__________C_________D_____________________F_______G
-SCORPION-___Lvl 16___________________________________
____________________________main____292:288______________292_______288
____________________________sub______292:286______________292_______286
____________________________sub____________________________
____________________________sub____________________________
____________________________sub____________________________
____________________________sub____________________________
____________________________fort_______292:287____________292_______287
LoveJockey__________________________________________
____________________________main_____254:9________________254_______9
____________________________sub_______255:8_______________255_______8
____________________________sub_______58:148______________58_______148
____________________________fort_______248:11______________248_______11
Wrathly__________________________________________
____________________________main______578:22______________578_______22
____________________________sub_______579:22______________579_______22
____________________________sub_______577:22______________577_______22
____________________________fort_______565:25______________565_______25
____________________________fort_______576:21______________576_______21
____________________________fort_______578:29______________578_______29
____________________________fort_______588:27______________588_______27
Calixleo__________________________________________
____________________________main______101:10______________101_______10
____________________________sub_______183:226______________183_______226
____________________________sub_______185:224______________185_______224
____________________________sub_______139:458______________139_______458
____________________________sub_______140:458______________140_______458
____________________________fort_______138:461______________138_______461
Eddyzila__________________________________________
____________________________main______23:283______________23_______283
____________________________sub_______23:282______________23_______282
____________________________sub_______23:284______________23_______284
____________________________sub_______19:282______________19_______282
____________________________sub_______26:292______________26_______292
Aredes75__________________________________________
____________________________main_____380:16______________380_______16
____________________________sub_______415:56______________415_______56
____________________________sub_______406:115_____________406_______115
____________________________sub_______352:8________________352_______8
____________________________fort_______399:7________________399_______7
____________________________fort_______406:45______________406_______45
____________________________fort_______352:21______________352_______21
Etc...
I had to add in _____ because it didn't want to space out my data and then you couldn't see the columns very well so ignore those
So Column A I have the players name
Column B isn't filled in all the way but will have their level that they are, for example -SCORPION- is lvl16. Their level tells us how many sub cities they can have... Everyone has one main city but for every 3 levels, they get another sub city. For example lvl 1 to 3 have 0 sub cities (just the main), lvl 4-6 have 1 sub city, 7-9 have 2 sub cities, lvl 10-12 have 3 sub cities, lvl 13-15 have 4 subs, lvl 16-18 have 5, etc. I guess ignore column B since its just so I can see how many subs they have unless you know a way to input that or something....
Column C is what it is, so main (city), sub (city), fort, oasis.
Column D is the coordinates so 292:288. I have it written like that so I can easily copy some of this data and send it to friends on game so that is why I have column F and G.....
Column E is just blank space to separate columns
Column F and G is Column D copied over and then I did "Data --> Text to Columns --> Delimited :" I did that so that I could make a chart of those numbers since before hand there are text. So 292:288 becomes x= 292 and y= 288.
I want scatter charts to have scale for x and y of 0-600. I want Y values in reverse order. I would like there to be major (and maybe minor) gridlines.
Please help.... I'm assuming I'm going to have to use macro.. but no idea what the code should be.....