excel 拖动滚动条
Last week, I shared a tip for using a scroll bar to change the date range in a report. The scroll bar selects the end date for the report, and the columns to the left show the two previous months.
上周,我分享了一个使用滚动条更改报告中日期范围的技巧。 滚动条选择报告的结束日期,左列显示前两个月。
It works very nicely, without programming, and makes it easy to view a different date range.
它无需编程就可以很好地工作,并且可以轻松查看不同的日期范围。
将图表标题链接到工作表单元格 (Link Chart Title to Worksheet Cell)
This week, we'll add a chart that shows the data for the selected date range. Then, we'll change the worksheet heading to a formula, so it shows the selected dates. Finally, we'll link the chart title to the heading cells, so it also shows the selected dates.
本周,我们将添加一个图表,显示所选日期范围内的数据。 然后,我们将工作表标题更改为公式,以便显示所选日期。 最后,我们将图表标题链接到标题单元格,因此它还会显示选定的日期。
Oops! You'll notice that I forgot to change Axis Title, that was added at the left side of the chart. If you use one of the Quick Layout options for charts, watch for those little extras that they might add.
糟糕! 您会注意到,我忘记更改在图表左侧添加的“轴标题”。 如果对图表使用“快速布局”选项之一,请注意它们可能会添加的那些小附加功能。
You can see the steps in the video, at the end of this post.
您可以在这篇文章的结尾看到视频中的步骤。
另一个图表标题示例 (Another Chart Title Example)
You can see another example of linking a chart title to a worksheet cell in my post on pivot table report filters. Instead of a simple link, you can use the IF function to affect the result, as in the formula shown below.
在我的数据透视表报表过滤器上,您可以看到另一个将图表标题链接到工作表单元格的示例。 您可以使用IF函数来影响结果,而不是简单的链接,如下所示的公式。
观看图表标题视频 (Watch the Chart Title Video)
To see the steps for creating the chart, and adding the dynamic title, you can watch this short video tutorial.
要查看创建图表和添加动态标题的步骤,您可以观看此简短的视频教程。
翻译自: https://contexturesblog.com/archives/2012/12/04/scroll-bar-changes-excel-chart-title/
excel 拖动滚动条