In this Excel charting tutorial lesson, you will learn how to insert a chart with a scrollbar in Excel application. This kind of chart could be useful for more complicated data sets.
How to create a scroll bar chart?
Consider the data and determine where your data set is going to be.
Now, look at where you want your dynamic range. This cell is ultimately going to drive the data that's reflected within your chart.
Now press the Ctrl+F3 keyboard shortcut. A window like the one shown below appears. Click New.
A New Name window will appear. Fill the Name field as Amount and press OK.
Again Name Manager window will appear. Choose New.
When a New Name window appears. Fill in the Name field with the Date and press OK.
Here you'll insert the chart. For this, select a 3D column chart. To add the chart, first select your data table. Next, go to ribbon. Click Insert > Column > 3D Column. The following chart will be created.
How to add a scroll bar to the chart?
Enable your Developer tab in the ribbon. To do this, go to File > Options > Customize Ribbo. Check the box for Developer. Now under the Developer ribbon's tab, choose Insert > Scroll Bar.
Then insert the scroll bar anywhere in the chart window. Then right-click the scroll bar and select Format Control.
On the Control tab, enter the Cell Link.
Then left click on the chart and under the Chart Tools select Design then Select Data. Select Amount and Edit; the Edit Series is displayed last.
Choose Edit under the Horizontal Axis Labels.
Select the Date series from your sheet.
Here you go with a scrollable plot.
Scrollbar is above the chart. You can click it to change the range of data presented.
Further reading: Dynamic Chart Interactive Dashboard