I would like to runa macro that creats a chart, then show the chart in a form.
Can that be done?

On Mar 26, 4:48*am, JudgeMental
<JudgeMen...@discussions.microsoft.com> wrote:
> I would like to runa macro that creats a chart, then show the chart in a form.
> Can that be done?

You can save a pre created chart as picture and use that on a form,
all through a macro. Visit John Walkenbach's http://j-walk.com/ss/excel/tips/tip66.htm
page for more details.

Anant

An alternative from Stephen Bullen that copies the chart and places the
contents into an image control in bitmap or metafile format:

"The userforms in Excel 97 are great, apart from one BIG letdown - you can't
put charts on them!"
http://oaltd.co.uk/DLCount/DLCount.a...stePicture.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


<(E-Mail Removed)> wrote in message
news:126dbae7-0ca8-42bd-92c5-(E-Mail Removed)...
On Mar 26, 4:48 am, JudgeMental
<JudgeMen...@discussions.microsoft.com> wrote:
> I would like to runa macro that creats a chart, then show the chart in a
> form.
> Can that be done?

You can save a pre created chart as picture and use that on a form,
all through a macro. Visit John Walkenbach's
http://j-walk.com/ss/excel/tips/tip66.htm
page for more details.

Anant