VB to create histogram

  • Thread starter Thread starter Harley Feldman
  • Start date Start date
H

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
 
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
 
Back
Top