excel集成系统单机版_单击地图以筛选Excel数据

excel集成系统单机版

单击地图以筛选Excel数据 (Click a Map To Filter Excel Data)

We'll set up an Excel workbook so you can click on a map, and see a list of fictional doctors in the state that you selected.

我们将设置一个Excel工作簿，以便您可以单击地图，并在您选择的状态下查看虚构医生的列表。

设置地图 (Set up the Map)

First, I found a clip art map of the continental USA, with a separate shape for each state, and pasted that into a workbook.

首先，我找到了美国大陆的剪贴画地图，每个州都有单独的形状，然后将其粘贴到工作簿中。

Next, I named the shapes, using the two digit state abbreviation.

接下来，我使用两位数字状态缩写来命名形状。

• Click on a state shape, e.g. Washington
  单击状态形状，例如华盛顿
• Click in the Name Box, and type the two digit code – WA