If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
displaying charts from Macros
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 |
#2
|
|||
|
|||
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/ _______ Tony wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Subreport Charts displaying no data | Chris S | Setting Up & Running Reports | 0 | June 10th, 2004 11:10 PM |
Pop up window about macros keeps displaying | steve | New Users | 3 | April 29th, 2004 09:46 PM |