ExcelQuickZoom

MS Excel macro for quickly zooming and panning a line chart

Watch Demo on Youtube:

http://youtu.be/S9mmAU8LJlQ

Getting Started (Easy):

1. Click and download ChartSampleWithQuickZoom.xlsm
2. Add your own data
3. Create new line chart(s) on analysis sheet
4. Scroll/Pan as needed
5. Copy/paste chart to new location.

Alternative: create spreadsheet from scratch:

1. Create a new Excel spreadsheet
2. Import the ChartMacro.vb source code
3. Create the following Names in Name Manger under Formulas and assign each to a cell
4. Scroll_Amount
5. Set_Thickness
6. Set_X_Start
7. Set_X_End
8. Zoom_Amount
9. Create buttons using the Insert menu under the Developer ribbon and assign to the following macro functions
10. Zoom_In
11. Zoom_Out
12. Left_Scroll
13. Right_Scroll
14. Go_To_X_Range
15. Set_Series_Thickness
16. Import data and create charts (same as above)