Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
display worksheet on form Jakem Schott Excel Programming 2 December 22nd 06 12:35 AM
Can I display an Excel chart as my screensaver display? Burke Charts and Charting in Excel 0 August 1st 06 07:01 PM
display a user form WBTKbeezy Excel Programming 0 June 2nd 06 08:41 PM
Is it possible to display cell value on a form? Bill Excel Programming 2 February 24th 06 02:42 AM
Form display errors Stuart[_5_] Excel Programming 0 December 17th 03 08:37 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"