[ Dec. 2001 ] [ Nov. 2001 ] [ Oct. 2001 ] [ Sept. 2001 ] [ August 2001 ] [ July 2001 ] [ June 2001 ] [ May 2001 ] [ April 2001 ] [ Mar. 2001 ] [ Feb. 2001 ] [ Jan 2001 ]
[ UF_smrIsVisible01 ] [ UF_USFedTax ] [ VBA_LabelBubblesAC ]
|
6:30-7:15 pm
|
Introduction: General
Questions and Problems from the Audience Puzzler:
Reprise: When I use Autofilter a table, I want my totals to sum on only
the rows that pass the filter, i.e. the visible rows.
This is actually harder than you would think. A
typical SUM() will include values from the hidden
rows.
There are several work-arounds, but I know only one way to do it in
place and it requires a simple User Function. Other
solutions are welcome.
Also: the First of a Series to introduce User Defined
Functions and how they can be use to simplify large
formulas.
See Example.
|
|
7:15-8:00 pm
|
The Application this month is to take a
table of stock data, create some calculated columns, then plot the
calculations on a A Bubble Chart. Use data to size the
bubbles. Then use a provided VBA subroutine to
make the label of each Bubble be the Stock SYMBOL for easy
identification of each point. See Example
below
Zipped XL97 Example workbook
67KB zipped. |
|
8:00-8:10 pm
|
(Break) |
|
8:10-9:00 pm
|
Continuation of the Labeled Bubble Chart
 | Bubble Charts |
| Apply a VBA subroutine to label your data. |
| Understanding the VBA subroutine for use in
other projects. |
|
Preliminary Notes for
the Presentation: (Word 97, 57 KB, not compressed).
Picture of the end product. The
Bubbles are labeled by a live formula to the data sheet. With this
method, the Label and the X,Y, Size of each bubble are always consistent.
Top of the Page
|
