
Excel Powerful Add-ins for Graph Analysis
Short Demonstration
Introduction
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
Full Demonstration
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.
Installation instructions
-
Download the Add-in file to your computer.
-
Open an excel file.
-
In the Tab list above, look for the Developer tab.
-
If you do not have the developer tab, Go to File tab and look for "Options" and then Add-Ins".
-
A window will open. below there is the following :Manage: Excel Add-Ins and Go button. push it!
-
Click the "Browse" button and paste the .xlam file you downloaded to your computer to here.
-
Click O.K. and that's it!
-
-
If U have the developer tab, click on it and then click the Add-Ins tab.
-
Use the same procedure as in 4.2 and 4.3 to install it on your computer
-
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
-
After placing the file in the trusted location, repeat step 4 (Click the "Browse" button and write the trusted location address in the search window.
-
The trusted location will open. Select it and press OK.