Can I display a chart in a form?
 

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

Can I display a chart in a form?
 

On Mar 26, 4:48*am, JudgeMental
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

Can I display a chart in a form?
 

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
_______


wrote in message
...
On Mar 26, 4:48 am, JudgeMental
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