A Class Module to Manipulate a Chart SERIES
Category: Developer Files | [Item URL]
- Description: A useful class module that makes it easy to work with the data used by a chart.
- Has Macros? No
- More Information: Click here
- Download: ChartSeriesInfo Class.xls
AcitveX Control Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates the use of ActiveX controls on a worksheet.
- Has Macros? Yes
- More Information: Click here
- Download: controls on sheet.xls
Analog Clock Chart
Category: General Files / Developer Files | [Item URL]
- Description: This workbook contains an XY chart that displays a working analog clock. It uses VBA to update the clock every second. This is really not a practical application. Rather, it's an interesting charting demonstration that uses VBA. The VBA project is not protected, so you can view the code.
- Has Macros? Yes
- Download: clockchart.xls
Toolbar Calculator
Category: Developer Files / Add-Ins | [Item URL]
- Description: An add-in that displays a new toolbar that functions as a simple calculator.
- Has Macros? Yes
- More Information: Click here
- Download: calculator toolbar.xla
Dice Roller
Category: General Files / Developer Files | [Item URL]
- Description: This workbook simulates rolling two dice. It keeps track of the results, and plots the distribution in a chart (along with the expected distribution). This may be useful in an elementary probability/statistics course -- or, some of the VBA techniques may be of value (the VB Project is not protected).
- Has Macros? Yes
- Download: diceroller.xls
An Animated Hypocycloid Chart
Category: General Files / Developer Files | [Item URL]
- Description: This workbook displays an infinite number of dazzling animated charts, similar may remind you of Hasbro's popular Spirograph toy.
- Has Macros? Yes
- More Information: Click here
- Download: hypocycloid - animated.xls
Climate Data Workbook
Category: General Files / Developer Files | [Item URL]
- Description: A highly interactive charting workbook that lets you compare the climate of two U.S. cities. It uses no macros.
- Has Macros? No
- More Information: Click here
- Download: climate_data.xls
[Previous page]
Excel Downloads
This section contains free Excel workbooks and add-ins. With a few exceptions, all of these files were developed by me -- John Walkenbach. Some of the files demonstrate useful techniques that you can adapt to your own work. Others are simply for fun.
The files are grouped into three categories: General Interest, For Developers, and Add-Ins. The files may not be compatible with all versions of Excel.
All Downloads
Browse Downloads by Category
Also of Interest
How to download
Most of the download links point directly to Excel files, but a few are compressed ZIP files. For best results: