bjsatola
08-11-2011, 03:06 PM
Some background:
In the past, I have used OWC11 to succesfully chart within UserForms
Download Link: microsoft<<dot>>com/download/en/details.aspx?id=22276
This has been done using Excel 2007 on a 32-bit Vista machine.
I perform and store many calculations in MS Access, and use Microsoft Excel VBA as the user interface using UserForms.
My application requires charting within these UserForms (i.e. pasting image-files of charts is not a solution).Problem:
I'm now running Excel 2010 on Windows 7 64-bit machine.
I've re-installed OWC11, but I am having trouble adding the Chartspace control to the Toolbox (Right-click > Add Controls > MS Office Chart XX.X is not there to reference OWC11).
Where has the Chartspace control gone???My humble plea : pray2::
I am rather fond of charting within a UserForm, and I am fustrated that Microsoft seems to no longer support this feature (i.e. no new versions of OWC out there?).
I need to know how to add a Chartspace control to the Toolbox.
Alternative solutions are welcome as long as I can chart within the UserForms, but enabling the Chartspace control would be prefered (so I don't have to do major code changes).Any assistance would be greatly appreciated; best regards,
>>B
In the past, I have used OWC11 to succesfully chart within UserForms
Download Link: microsoft<<dot>>com/download/en/details.aspx?id=22276
This has been done using Excel 2007 on a 32-bit Vista machine.
I perform and store many calculations in MS Access, and use Microsoft Excel VBA as the user interface using UserForms.
My application requires charting within these UserForms (i.e. pasting image-files of charts is not a solution).Problem:
I'm now running Excel 2010 on Windows 7 64-bit machine.
I've re-installed OWC11, but I am having trouble adding the Chartspace control to the Toolbox (Right-click > Add Controls > MS Office Chart XX.X is not there to reference OWC11).
Where has the Chartspace control gone???My humble plea : pray2::
I am rather fond of charting within a UserForm, and I am fustrated that Microsoft seems to no longer support this feature (i.e. no new versions of OWC out there?).
I need to know how to add a Chartspace control to the Toolbox.
Alternative solutions are welcome as long as I can chart within the UserForms, but enabling the Chartspace control would be prefered (so I don't have to do major code changes).Any assistance would be greatly appreciated; best regards,
>>B