I would like to create a map of the U.S in Powerview with 2 sets of bubbles showing number of hospitals in each state (as blue bubbles) and the number of nursing homes in each state ( as red bubbles). My data table is simple as follows:
state #hospitals #nursing homes
Alaska 45 73
Alabama 35 55
etc.
Problem is only the first variable (hospitals) show up as bubbles on the map. How do I get both bubbles to appear in each state? Maybe a map in Powerview is not the right software. Clearly some software should be able to do this, right?
Thanks.
state #hospitals #nursing homes
Alaska 45 73
Alabama 35 55
etc.
Problem is only the first variable (hospitals) show up as bubbles on the map. How do I get both bubbles to appear in each state? Maybe a map in Powerview is not the right software. Clearly some software should be able to do this, right?
Thanks.