Excel Tutorial - Creating Zoom Chart

 

Step 1: Create data

In a new workbook, create a worksheet and name it as "Zoom". Enter the following data to the worksheet in cell A1:B13.

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

Step 2: Define 2 names

 

Go to Formulas Tab->Name Manager->Define and add the following 2 names

ChartLabel=OFFSET(Zoom!$A$2,0,0,Zoom!$J$2,1)

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

ChartData=OFFSET(Zoom!$B$2,0,0,Zoom!$J$2,1)

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

Step 3: Show Developer Tab

 

Excel 2007 

Click the Microsoft Office Button Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka , and then click Excel Options.

Click Popular, and then select the Show Developer tab in the Ribbon check box. 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

In Excel 2010, Click the File tab> Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box.

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

 

Step 4: Create a Scroll Bar

 

Go to Developer Tab->Insert->Form Controls->Scroll Bar (Form Control)

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

Click on D2 and drag to I2, to create a scroll bar that cover cell D2 to I2

 

Right Click on the scroll bar, and select Format Control.

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

 

In the dialog box, click on the Control tab

Set the Min Value and Max Value and the cell link

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

Step 5: Plot the chart

 

Select any empty cell, i.e cell D4

 

Go to Insert Tab->Charts->Column

-       an empty chart is created

 

Go to ChartTools-> Design-> Select Data

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

In the Select Data Source dialog box, Click on the add button:

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

In the Edit Series dialog box, create a series with the info as follows

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

Click OK

When you are back to the Select Data Source dialog box, Under Horizontal (Category) Axis Labels, click on Edit:

 

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

In the Axis Labels dialog box, create an Axis label range with the info as follows

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

Click OK

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

Step 6: Try it out!

 

Click on the scroll button on the scroll bar and see how the chart zooms in and out!

 

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

Excel Tutorial - Creating Zoom Chart | Cemtech Training Center Puchong Selangor, Melaka

 

 

By Bee Bee Ong 

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
Unit 6, Level 4, SetiaWalk Mall (Block K), SetiaWalk, Persiaran Wawasan, Pusat Bandar Puchong, 47160 Puchong, Selangor, Malaysia.
Tel: 603-80684461, Fax: 603-80684240
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka, Malaysia
Tel: 606-2835955, Fax: 606-2845955