by bmark0225 » Sat Nov 09, 2013 11:11 am
Hi Sisyphus
I appreciate your help, but seem like my previous post was not clear
i try to post it again, please help,
As you see in the sheet4 ( original data)
Column A is ID 1,2,3...
Column B is X axis
Column C is Y axis
Column D is Z axis
What i try to do is making a map with X and Y, then in the map whatever X,Y has Z value in the different range value has different color
What i am doing now ( on sheet1) is i have to sort column Z, then manually going to insert chart -> scatter->series ,and manually typing each series on, lot of work on that and easily make mistake ,
Anyway such as macro,any code that make it better,
Again, thank you so much for your help,
Mark
You do not have the required permissions to view the files attached to this post.