Zoom Chart Spreadsheet
Zoom Chart Excel spreadsheet allows the user to zoom and scroll scatter plot charts and navigate the data more easily. It's available as a spreadsheet and also as an Excel add-in (which allows to use the tool on all your spreadsheets).
I use it every time I need to get into the details of my test results.
Date of release: 01/09/2017
Compatibility: See release notes below
Available downloads (click to download):
After downloading the add-in, save it into a local folder. Then follow the instructions of the video shown here, linking to the downloaded file when requested.
The add-in will appear as a separate tab in Excel. Clicking on the button "open zoom chart" will activate the zoom chart tool.
Why I created the zoom chart tool
Some time ago I was doing some tests to verify the stability of a weigh cell after the positioning of a component over it. A normal response of a weigh cell would be divided in:
- Weigh raising time: the period when the weigh is raising because the component has been put over the weigh cell
- Settling time: the period when the weigh cell has reached the correct weight, but its value is still oscillating
- Steady time: the period when the transient is concluded and the weigh cell has reached a value that is within a certain acceptable error range
My target was to measure the time needed for weighing, so the time that passed between the positioning of the component on the weigh cell (start of period A) and a steady output (start of period C).
The weigh cell recorded a weigh reading every 20 ms on a csv file. I then imported the readings (time and weigh) on a spreadsheet and created a simple scatter plot chart, as shown in the figure. At this point I wanted to have a closer look at the chart to see how the readings behaved in the period B (e.g. was there an oscillation? Could I understand what caused this oscillation? Could I see the extension of the oscillation and measure it?).
I quickly discovered that Excel charts are not very easy to navigate, since the user needs to manually change the minimum and maximum values that are shown by the axis. This is quite a long procedure, which slowed the data analysis period a lot.
This is the reason why I decided to create the Zoom chart spreadsheet. It is a simple tool which allows the user to zoom or scroll the scatter plot chart and get a closer look to his data. The speed of the zoom and the scroll can be adjusted depending on the user preferences. It's possible to choose which axis to zoom, which can be quite handy.
The Zoom chart spreadsheet is available as a ready-to-use spreadsheet and also as an Excel add-in. This allows the user to embed the add-in in Excel and open it by just clicking a button. The zoom and scroll functionalities would then be ready to use on every spreadsheet, provided that a scatter plot chart has been created previously.
Zoom chart spreadsheet release notes
EnginExcel free spreadsheets are free for personal and commercial use.
Zoom chart spreadsheet is tested on Microsoft Excel 2007, 2010 and 2013 for Windows. Microsoft Excel for Mac is currently not compatible.
- Works with all Excel scattered plots
- Possible to add multiple scattered plots
- Chart zoom
- Allows selection of which axis to zoom
- Allows to define the speed of the zoom
- Chart scroll
- Allows to scroll up/down/left/right
- Allows to define the speed of the scroll
- Reset view button
- Excel Add-in available
|How to activate the zoom/move tool||- Click on the chart area (the white area around the chart)
- Click on the button "Start chart navigator"
|How to move the chart||- Activate the zoom/move tool
- Define the movement speed (use the scroll bar or type a number between 1 and 99 - the higher the number the higher the movement speed)
- Click on one of the movement buttons (Up/down/left/right)
|How to zoom the chart||- Activate the zoom/move tool
- Define the zoom speed (use the scroll bar or type a number between 1 and 99 - the higher the number the higher the zoom speed)
- Click on one of the zoom buttons (In/out)
|How to restore the original zoom and position of the chart||- Activate the zoom/move tool
- Click on "Reset view"
If you have any comments on this material I’ll be happy to receive your feedback. You can contact me here.
If you enjoy this free material but would like to have it customised for your needs feel free to contact me.