|
The following information demonstrates how to create your first Excel ActiveX Charting implementation. It discusses installation, adding ProEssentials to a sheet, writing your first few lines of code, and shows the final results.
This walkthrough uses 32 bit ActiveXs so this examples is for MS Excel 2013 32 bit.
| Installation... |
|
When installing ProEssentials, the setup program installs the ProEssentials DLL and ActiveX interfaces into the system directory. The setup program also registers the ActiveXs with the operating system, which prepares MS Access, MS Excel, Visual Basic for inclusion of ProEssentials components. You can manually register an ActiveX with "REGSVR32.EXE" found in your system32 or syswow64 on 64 bit systems. You can also use this utility to manually un-register an ActiveX by using the "-u" command.
|
PEGRP32G.DLL
|
ProEssentials Pro DLL |
| PEGOG.OCX |
Graph Object |
| PESGOG.OCX |
Scientific Graph Object |
| PE3DOG.OCX |
3D Scientific Graph Object |
| PEPSOG.OCX |
Polar Object |
| PEPCOG.OCX |
Pie Chart Object |
|
PEGRPSG.DLL
|
ProEssentials Standard DLL |
| PEGOSG.OCX |
Graph Object |
| PESGOSG.OCX |
Scientific Graph Object |
| PE3DOSG.OCX |
3D Scientific Graph Object |
| PEPSOSG.OCX |
Polar Object |
| PEPCOSG.OCX |
Pie Chart Object |
|
From the New menu, create a new Fitness tracker spreadsheet from list of templates.
The sheet opens showing the Fitness tracker template.
Right click the top menu, select Customize the Ribbon... then select the Developer check box to enable the Developer top menu.
With the Dashboard sheet showing...
Now click 1 Developer menu, 2 Insert Menu, and 3 the More Controls icon as shown below..
This opens the More Controls dialog showing all ActiveX controls registered on the system.
Note both ProEssentials v7 and v8 setup EXEs have been installed as both v7 and v8 are showing within the list of controls.
Highlight the Gigasoft Pego v9 control and select OK. This places the control on your sheet.
| Adding chart to the sheet... |
Referring to below image, delete the existing chart and position the ProEssentials chart in place.
Toggling Design mode off and on will allow chart to redraw itself.
| Adding Worksheet Activate event... |
Select Developer, and then View Code menu item to show the VB Code Editor.
Adjust the list boxes above code window so 'Worksheet' and 'Activate' items are shown. Then add the code below within the Activate event. Refer to image below showing the Excel VB code window.
|
