Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Colleyville Alan
 
Posts: n/a
Default Favorite utilities - VBA macros?

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






  #2   Report Post  
HS Hartkamp
 
Posts: n/a
Default


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.


"Colleyville Alan" wrote in message
...
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








  #3   Report Post  
CLR
 
Posts: n/a
Default

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


"Colleyville Alan" wrote in message
...
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








  #4   Report Post  
Colleyville Alan
 
Posts: n/a
Default

"CLR" wrote in message
...
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?


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.




Vaya con Dios,
Chuck, CABGx3


"Colleyville Alan" wrote in message
...
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










  #5   Report Post  
CLR
 
Posts: n/a
Default

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



"Colleyville Alan" wrote in message
...
"CLR" wrote in message
...
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?


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.




Vaya con Dios,
Chuck, CABGx3


"Colleyville Alan" wrote in message
...
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














  #6   Report Post  
Jon Peltier
 
Posts: n/a
Default

I have a rudimentary Box and Whisker macro he

http://peltiertech.com/Excel/Charts/...tml#BoxWhisker

which computes the required spacings from your raw data. It doesn't work
right if the numbers span the X axis (haven't followed my own
procedures for this yet), but otherwise you may find it useful.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Colleyville Alan wrote:

"CLR" wrote in message
...

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?



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.




Vaya con Dios,
Chuck, CABGx3


"Colleyville Alan" wrote in message
...

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










Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enabling macros Peter M Excel Discussion (Misc queries) 3 February 7th 05 11:57 PM
sorting with macros Sorting in macros Excel Discussion (Misc queries) 1 February 1st 05 10:02 AM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 01:21 AM
The available macros list in XL; how to suppress filename from showing KR Excel Discussion (Misc queries) 1 January 10th 05 08:20 PM
Macros disappear after a file is imported Brent E Excel Discussion (Misc queries) 1 December 18th 04 01:25 AM


All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"