Description: Zooming & Scrolling inside excel chart

If you are analyzing data using excel chart, sometimes you need to zoom in/out or scroll up/down to a specific data range.
 Repeating this step more than once can be frustrating and time consuming.

Zooming and scrolling using the powerful add-ins is simple and powerful.
All it requires is a mouse movement to define the zoom range or scrolling direction:

How it works:

Short description:

• Select the desired chart using the mouse
  • For Zooming in:
    • hold Ctrl key
    • Click left mouse key
    • Drag mouse along the chart to define the desired zoom area
    • Click left mouse key to apply zoom an the selected area 
  • For Zooming out:
    • Option no.1: Double click on the desired axis to zoom out by factor of 2​
    • Option no.2: Hold Alt key & double click on the desired axis to "Auto-scale"
  • For Scrolling:​
    • Hold Ctrl+Shift+left mouse key​
    • Drag mouse along the chart (x,y) to scroll

​

Full description:

1. Three options to zoom in:
Option 1a:

• Hold the Ctrl key and click the mouse key while moving the mouse over the desired range that you want to zoom in. This will create a rectangular which defines the area were you want to zoom in. 
• When you decided on the size and position of the rectangular,click again on the mouse button to launch the zoom in.
• Option 1b: (secondary axis)
• In case you have a secondary Y axis, first select the Y axis with the mouse (not double click) and then run the "Option 1a" procedure. In order to switch back to the Primary Y axis, select it and then run "Option 1a" procedure

Option 1c: (both primary & secondary axis)

• If you are interested in zooming both axis's, select the plot area ( instead of Y1,Y2) and then apply "Option 1a" procedure 

Option 2: (zoom x2)

• Holding the Shift+ALT and double click on the desired axis (X or Y1,Y2) U want to zoom in by factor of  x2
• The position of the mouse arrow (when double clicking) will impact the center of axis
  • e.g. if the axis range is 0..1000 and U double click on 500 it will change the axis range 250..750. however, if you click on 1000 it will change the range to 500..1000 

Option 3: ("floating rectangular")

• Every time the user selects the plot area, a Lens icon is formed on the top left corner of the chart. clicking on the icon forms a rectangular at the center of the chart
• Move the rectangular and reshape it to the desired place.
• double click on it to zoom
• This option is very helpful in case of large data ( >50,000 point)

2. Zoom-out (two options):

Option 1: (Auto scale)

• Zoom out to the original X or Y chart range by double clicking with the mouse on the desired axis to be zoomed out while holding the Alt key

Option 2: (zoom out X2)

• Zoom out by a factor of 2 i.e. mini zoom out, is done by double clicking with the mouse on the desired axis to be zoomed out. 

3. Scrolling:

• Scrolling in the X or/and Y direction is done by holding Ctrl, Shift and mouse key together while moving the mouse to the desired direction. 

​​

4. Command bar:

• Right click with the mouse outside the chart, pops up a standard roller bar with additional 5 options: Help, Enable, disable undo redo.

Installations instructions:

1. Download the Add-in file to your computer.
2. Open an excel file.
3. In the Tab list above, look for the Developer tab.
4. If you do not have the developer tab, Go to File tab and look for "Options" and then Add-Ins".
   1. A window will open. below there is the following :Manage: Excel Add-Ins and Go button. push it!
   2. Click the "Browse" button and paste the .xlam file you downloaded to your computer to here.
   3. click O.K. and that's it! 
5. If U have the developer tab, click on it and then click the Add-Ins tab.
6. Use the same procedure as in 4.2 and 4.3 to install it on your computer 
7. In case that the excel Add-ins is not loading, place the add-in in a Trusted Location (in Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations), such as the following folder, and load it from there:for example : C:\Users\%USER NAME%\AppData\Roaming\Microsoft\Excel\XLSTART

Links:

• Movie presenting the tool:
• https://www.youtube.com/watch?v=dpCAhtnh458
• https://www.youtube.com/watch?time_continue=4&v=TmZeWTGaxOU&feature=emb_logo
• https://www.youtube.com/watch?v=Ovkxr6OZGu4&feature=emb_logo