Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |