View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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