displaying charts from Macros

[Guest]

I would like to create the template which will present user with several data
entry forms, calculate result and then should presend result as a serie of
charts with next button to show next chart. Is it possible to display just
the chart windows for each chart or they have to be displayed on separate
sheets. Any suggestion on what is the most elegant solution to what I want to
do ?

Regards,

Tony

 

[Jon Peltier]

Tony -

The chart windows are not stable; they disappear when the user clicks anywhere else.
But I don't think you really mean chart windows as such.

You can make embedded charts. From Location on the Chart menu or in step 4 of the
wizard, change to Object On, and select the sheet in the dropdown. In VBA, it's the
..Location property of the Chart object, or simply create a chart object instead of a
chart sheet:

ActiveSheet.ChartObjects.Add(<positions and dimensions in points>)

instead of

Charts.Add

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