excel图表配合下拉菜单_在下拉列表中选择Excel仪表盘图表

excel图表配合下拉菜单

You can make an interactive dashboard in Excel, even if you can't use macros, or prefer to avoid them. Select a chart or chart data from a drop down list, and the selected item will instantly appear on the dashboard – no macros required.

您可以在Excel中制作一个交互式仪表板，即使您不能使用宏，也可以避免使用宏。 从下拉列表中选择一个图表或图表数据，所选项目将立即显示在仪表板上-无需宏。

See how to build this dashboard, watch the video, and download the sample file to see the completed version.

了解如何构建此仪表板，观看视频并下载示例文件以查看完整版本。

命名范围 (Name That Range)

In the screen shot above, "Chart Data – East" is selected in the drop down list, and that data will appear on the dashboard, replacing the current data.

在上面的屏幕快照中，在下拉列表中选择了“图表数据-东”，该数据将出现在仪表板上，替换当前数据。

There are 4 choices in the drop down, and on a separate worksheet (ChartInfo), there are four matching ranges, shown below.

下拉菜单中有4个选择，在单独的工作表(ChartInfo)上，有四个匹配范围，如下所示。

• ChartData
  图表数据
• EastData
  东数据
• ChartRange
  图表范围
• ChartEast
  东图

The contents of the selected range will appear on the dashboard.

所选范围的内容将出现在仪表板上。

下拉列表项目 (Items for the Drop Down List