Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use histogram in vba code - analysis toolpack
I want to use histogram as provided in analysis toolpack using visual basic
macro but could not do that. Is there a way to code for this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use histogram in vba code - analysis toolpack
Use the add-in Anaylsis ToolPack VBA - then use
Application.Run "ATPVBAEN.XLA!Histogram" You will need to set the parameters for this command and the best way is to turn on the macro recorder and set up the histograms options in the wizard. You can then adapt the recorded macro within your VBA program code. -- Cheers Nigel "Davervin" wrote in message ... I want to use histogram as provided in analysis toolpack using visual basic macro but could not do that. Is there a way to code for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpack add-in gets disabled | Excel Worksheet Functions | |||
how do i set up analysis toolpack? | Setting up and Configuration of Excel | |||
how can I get analysis toolpack for anova calculations | Excel Worksheet Functions | |||
How can I Install Analysis ToolPack (add-in) without the instal CD | Setting up and Configuration of Excel | |||
Analysis ToolPack For Excel 2002 | Excel Discussion (Misc queries) |