Tag Archives: filter chart data

Zoom & filter chart data using scroll bar form control

The scroll bar, in the form control group, is a very effective tool that can be used in dashboards to filter data—specially date values. In this post I will show how it can be used to create a zoom effect on graphs and simultaneously filter data based on dates. You can download the workbook that I created for this post, here (.xlsx – yes no VBA) and the final product looks like this:

Scroll Bar Zooming on Chart

Before I explain what I did and how I did, let’s have a look at the form control scroll bar (I know most of you already know what it is but for those who don’t, I don’t want you to start searching the internet :) ). You can find the Scroll Bar control in MS Excel > Developers Tab > Insert > Form Control > Scroll bar Continue reading