spot_img

How To Create A Chart With Scrollbar In Excel

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.

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

data table

 

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

 

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

name manager

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

New Name

Again Name Manager window will appear. Choose New.

name manager click new

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

fill name Date

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

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

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

Format Control

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

Here you go with scrollable plot.

chart with Scrollbar ready

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

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell