VB to create histogram

[Harley Feldman]

I am trying to create a histogram using VB with data that I input and bin data records available. When I chose the macro recorder while creating the histogram, I only received the following line of code:

Application.Run "ATPVBAEN.XLA!Histogram", , "", , False, False, False _
, True

I am not sure what these parameters represent, and I don't see where the input or bin ranges are entered. What code is required to make the histogram data analysis work?

Harley

 

[Michael R Middleton]

Harley -

You can download a free add-in from the "Better Histogram" page at
www.treeplan.com. The VBA code isn't protected, so you can use it as is or
modify it for your needs. It doesn't use the Histogram tool, but it may be
satisfactory. If you take a look at it, please give me some feedback.
Alternatively, you will likely eventually receive some replies about using
the Analysis ToolPak Histogram add-in.

- Mike

www.mikemiddleton.com

+++++++++++++++++++++++

I am trying to create a histogram using VB with data that I input and bin
data records available. When I chose the macro recorder while creating the
histogram, I only received the following line of code:
Application.Run "ATPVBAEN.XLA!Histogram", , "", , False, False, False _
, True
I am not sure what these parameters represent, and I don't see where the
input or bin ranges are entered. What code is required to make the
histogram data analysis work?
Harley

 

[Lonnie M.]

Hi, you could create the chart ahead of time and then update the data
with your code.
Then you can do whatever you wish with the chart--copy, export as a
'.gif', hide, unhide--the sky is the limit, almost.
You might also want to search under the following group:
http://groups-beta.google.com/group/microsoft.public.excel.programming
Good Luck! Lonnie M.