mt4单击显示图表
单击以显示或隐藏Excel图表数据 (Click to Show or Hide Excel Chart Data)
If you’re building Excel reports for other people to use, you can add a few interactive chart features, to let people customize the reports.
如果要构建供其他人使用的Excel报告,则可以添加一些交互式图表功能 ,以使人们可以自定义报告。
In this example, there is a check box beside each region name, in the sales summary table.
在此示例中,销售摘要表中每个区域名称旁边都有一个复选框。
- If you add a check mark, that region’s data is shown in the chart. 如果添加复选标记,则该区域的数据将显示在图表中。
- If you clear the check mark, the region’s data disappears from the chart. 如果清除复选标记,则该区域的数据将从图表中消失。
![chartinteractive01 chartinteractive01](https://i-blog.csdnimg.cn/blog_migrate/15d8ee89f9e669cb42a7745846f29982.png)
This is based on a technique that I learned from Jon Peltier, who creates amazing Excel charting utilities.
这是基于我从乔恩·Perl捷(Jon Peltier)那里学到的技术的,他创建了出色的Excel图表实用程序 。
无需编程 (No Programming Required)
There’s no programming required for this technique – the chart is based on a duplicate set of data, which uses the NA function to prevent data from being displayed.
此技术无需编程-图表基于重复的数据集,该数据集使用NA函数防止显示数据。
![chartinteractive03 chartinteractive03](https://i-blog.csdnimg.cn/blog_migrate/72f1a3e11446b5cc7e06e1593364164d.png)
The technique works best for small to mid-sized tables, if you’re setting it up manually. Each check box is linked to a cell in the duplicate data range, and that would be a pain to set up for a long list.
如果您手动设置,则该技术最适合中小型表。 每个复选框都链接到重复数据范围中的一个单元格,要设置一个较长的列表会很麻烦。
测试交互式在线图表 (Test the Interactive Online Chart)
To see how the chart works, you can test the interactive online version of the chart and worksheet, shown below. (It might not be visible in all browsers.)
若要查看图表的工作原理,可以测试图表和工作表的交互式在线版本,如下所示。 (它可能并非在所有浏览器中都可见。)
Check boxes aren’t available in the interactive online view, so this example uses "X" marks instead.
交互式在线视图中没有复选框,因此本示例使用“ X”标记。
- Type an X in column A, to show a region. 在A列中键入X,以显示区域。
- Clear the cell in column A, to hide a region. 清除列A中的单元格以隐藏区域。
下载样本文件 (Download the Sample File)
To see the detailed instructions, and to download the sample file, please visit my Contextures website: Excel Charts – Add Interactive Features. ______________
要查看详细说明并下载示例文件,请访问我的Contextures网站: Excel图表–添加交互式功能 。 ______________
翻译自: https://contexturesblog.com/archives/2013/03/05/click-to-show-or-hide-excel-chart-data/
mt4单击显示图表