VB to create histogram

TheMSsForum.com: The Microsoft Software Forum

This is a multi-part message in MIME format.

------=_NextPart_000_001F_01C4E481.9D997310
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

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
------=_NextPart_000_001F_01C4E481.9D997310
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>I am trying to create a histogram using VB with data =
that I=20
input and bin data records available.&nbsp; When I chose the macro =
recorder=20
while creating the histogram, I only received the following line of=20
code:</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>&nbsp;&nbsp;&nbsp;&nbsp; Application.Run=20
"ATPVBAEN.XLA!Histogram", , "", , False, False, False=20
_<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , True<BR></FONT></DIV>
<DIV><FONT size=3D2>I am not sure what these parameters represent, and I =
don't see=20
where the input or bin ranges are entered.&nbsp; What code is required =
to make=20
the histogram data analysis work?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>&nbsp; Harley</DIV></FONT></BODY></HTML>

------=_NextPart_000_001F_01C4E481.9D997310--
Top

Re: VB to create histogram by Michael

Michael
Sat Dec 18 00:50:17 CST 2004

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

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

"Harley Feldman" <harleyfeldman@msn.com> wrote in message
news:efeAnPL5EHA.3644@tk2msftngp13.phx.gbl...
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


Top

Re: VB to create histogram by Lonnie

Lonnie
Sun Dec 19 16:26:11 CST 2004

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.

Top