Favorite utilities - VBA macros?

  • Thread starter Thread starter Colleyville Alan
  • Start date Start date
C

Colleyville Alan

I've seen a number of utilities at the various MVP sites and while many of
them are quite good, I am interested in learning about other utilities that
I have not yet discovered. So, in that vein, I have a couple of question:

1 - What are your favorite charting utilities or macros?
(free, shareware, commercial, etc).

2 - What would you like to see developed to help with charting?
(I'm not a developer, but an answer to this question might give me insight
into issues that I have not considered when designing charts)

Thanks
Alan
 
My favourites are a toolbar-button to copy any selection as a picture to
power point (to the current slide), and the xy-chart labeler.

Apart from this, I created a macro that imports the results of a query from
access. All of these I use in my work very frequently.

Bas Hartkamp.
 
I don't really get into much charting, but recently a user asked my help
with his X-Y Scatter Chart and Third Order Polynomial
Trendline................With help form these groups, I managed to automate
the creation of the whole thing and put all the LINEST calculations on the
sheet as well as some other statistical calculations, and provided a 2
colunn by 25 row Data entry area where he could enter as little or as much
data as he liked and "Push the Button" and the macros run the whole
thing................

Is this the sort of thing you're asking about?

Vaya con Dios,
Chuck, CABGx3
 
CLR said:
I don't really get into much charting, but recently a user asked my help
with his X-Y Scatter Chart and Third Order Polynomial
Trendline................With help form these groups, I managed to
automate
the creation of the whole thing and put all the LINEST calculations on the
sheet as well as some other statistical calculations, and provided a 2
colunn by 25 row Data entry area where he could enter as little or as much
data as he liked and "Push the Button" and the macros run the whole
thing................

Is this the sort of thing you're asking about?
Click to expand...

Pretty much. I have built a few unusual graphs by hand that are rather
time-consuming. I have seen some utilities that help with labeling and a
few other items, but not too many general purpose utils. So I thought I'd
check to see what others have run across or developed on their own.

For example, if I want to show where a stock has performed vs quartiles, I
can construct a stacked bar chart, set the bottom segment area and border to
"none", color the quartiles, and change the graph type of one segment to
have the returns data set appear appropriately within the correct quartile.
But that is rather time-consuming if I build it strictly by hand as I now
have to calculate how much "padding" to use in the first, invisible segment
(not difficult, but not fast either). Then there is formatting, etc. I
could have a saved graph and just overwrite the data, but that is a bit
limiting in other ways.

OTOH, a util that calculates the "padding", grabs the return set and changes
the graph type for it, does all of the formatting, etc would be a better
choice. Maybe a wizard with check boxes to turn on or off various
formatting options. Recording a macro in VBA is not difficult, but turing
that into a useful utility is (at least for me). So any debugged macros or
utilities (free, shareware, or commercial) are worth looking into for me.
 
My limited experience with charting indicates that each situation and or
user-preference seems to be almost a unique situation. Leaving very little
to be carried over from job to job........but one thing I've learned about
making macros useful, is to record, or write only small segments into
individual (single purpose) macros.....then write a master macro(s) that
calls whichever segments you wish in that particular instance...........this
also helps with de-bugging.

Good luck finding any available utilities you're looking for, and when/if
you do, please post back to share them.............

Vaya con Dios,
Chuck, CABGx3
 
Back
Top