PDA

View Full Version : Hello: Sales Tracking



JFBino
05-26-2010, 12:47 PM
Just bought MapPoint to help me visualize and to conduct time & territory management. I have 165 accounts in 12 Northestern States. Using color coded push pins based on $ Sales will help me prioritize. Hope this doesn't take long to figure out!:v2v:

Eric Frost
05-26-2010, 01:04 PM
Good luck, let us know if you get stuck.

Eric

JFBino
05-26-2010, 02:28 PM
Eric,
I have an excel file that has column headings: Acct #; Name; Address; City; State; Zip; annual Sales $.
I want to use the Multiple Symbol map andhave the symbol located on the street address with a color code for the amount of sales range. My sales to accouts go from $0-$250,000. Thus if there are 8 ranges, I would like them to be: 0-25,000;25,000-50,000; 50,000-75,000; 75,000-100,000; 100,000-150,000; 150,000-200,000; 200,000-250,000; 250,000-500,000.
Each of those ranges a different color.
I have been using the wizard and just can't figure out the way to have a range associated with a symbol color.
Thanks in advance. What am I missing?
Kindest regards,
Jim