How to create a chart with scrollbar?

Today you will teach yourself how to insert a chart with a scrollbar in Excel application. This kind of chart could be useful for more complicated data sets.

1. Consider the data, and determine where your data set is going to be.

data table

 

2. Now, look where you want your dynamic range. This cell is ultimately going to drive the data that's reflected within your chart.

dynamic range

 

3. Now press Ctrl+F3 keyboard shortcut. A window like shown below appears. Click New.

name manager

4. A New Name window will appear. Fill the Name field as Amount and press OK.

New Name

5. Again Name Manager window will appear. Choose New.

name manager click new

6. When a New Name window appear, fill the Name field with Date and press OK.

fill name Date

7. 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.

3-D bar chart

8. Enable your Developer tab in 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.

Insert Scroll Bar

9. Then insert the scroll bar anywhere in the chart window. Then right click the Scroll bar and select Format Control.

Format Control

10. On the Control tab, enter the Cell Link.

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 Lastly.

edit series

choose Edit under the Horizontal Axis Labels.

select data source

Select Date series from your sheet.

axis labels

11. Here you go with the chart with Scrollbar.

chart with Scrollbar ready

Scrollbar is above the chart. You can click it to change the range of data presented.