Hello, I’m an average user on Excel.  I’ve created a simple spreadsheet for our local historical society to enter business information from city directories with column headings of “business name,” “street address,” “city,” “state,” “business category” “owner(s)” and then several columns following with the years of the city directories.  As business information is entered from each directory, the user simply enters an X in the corresponding year column.  We would like to be able to see locations of these businesses on a city map by corresponding year.  I was thinking that prompts for the user to choose a city directory year and another prompt for the user to choose a business category.  Regarding the business category, I was also thinking about allowing the user to either choose 1 or any number of categories, along with the choice of all categories too.  If that is possible?  I’ve seen some videos about Map charts and I’m not sure if this would work or if something else would be more feasible.  Any help would be greatly appreciated.

Thanks,

James

​Hello, I’m an average user on Excel.  I’ve created a simple spreadsheet for our local historical society to enter business information from city directories with column headings of “business name,” “street address,” “city,” “state,” “business category” “owner(s)” and then several columns following with the years of the city directories.  As business information is entered from each directory, the user simply enters an X in the corresponding year column.  We would like to be able to see locations of these businesses on a city map by corresponding year.  I was thinking that prompts for the user to choose a city directory year and another prompt for the user to choose a business category.  Regarding the business category, I was also thinking about allowing the user to either choose 1 or any number of categories, along with the choice of all categories too.  If that is possible?  I’ve seen some videos about Map charts and I’m not sure if this would work or if something else would be more feasible.  Any help would be greatly appreciated.Thanks,James  Read More

​