Can I display a chart in a form?

  • Thread starter Thread starter JudgeMental
  • Start date Start date
J

JudgeMental

I would like to runa macro that creats a chart, then show the chart in a form.
Can that be done?
 
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.asp?file=PastePicture.zip

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


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

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help: Chart & data 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Why do charts disappear? 2
HIDE VALUE 0 FROM CHART 1
Paste Excel chart in Powerpoint - how to "send to back" the pasted chart 1
Chart rotation 3
Paste Excel Chart into Existing Powerpoint Chart 1
Excel 2010. How to copy chart format to all charts in sheet 2

Back
Top