Need Help with using the Object Microsoft Office Excel Charts in Client

HCL Domino Domino Forum
1

I really need some help with graphing/charts.

I found a great post that talks about inserting an Microsoft Office Excel Charts Object into a form and then using an action button to populate a chart as needed.

http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/7a9a6c7c40c42e8d852572ed001578cb?OpenDocument

I’m now stuck. I need to know what properties/methods are available to further enchance the use of this object. Where can I go to find this information? I want to change the legend, colors, etc. Basically anything I can change on the object, I want to know how to code to change it.

The code I’m currently using is the following (courtesy of the post mentioned above):

Dim ws As New NotesUIWorkspace

Dim uidoc As NotesUIDocument

Dim Excel As Variant,Chart As Variant

Dim sheet As Variant

Set uidoc = ws.CurrentDocument

Set Excel = uidoc.GetObject("Microsoft Office Excel Chart")

Set chart = Excel.ActiveChart

Set sheet = Excel.Worksheets("Sheet1")

chart.ChartType =51    ' -4101 '-4102 is pie

chart.Elevation = 2

	

sheet.Cells(1,1) = "Operating System"

sheet.Cells(2,1) = "Windows Server 2003"

sheet.Cells(3,1) = "Windows XP"

sheet.Cells(4,1) = "Windows 2000"

sheet.Cells(5,1) = "Windows NT 4.0"

sheet.Cells(6,1) = "Other"



sheet.Cells(2,2) = Uidoc.FieldGetText("Field1")

sheet.Cells(3,2) = Uidoc.FieldGetText("Field2")

sheet.Cells(4,2) = Uidoc.FieldGetText("Field3")

sheet.Cells(5,2) = Uidoc.FieldGetText("Field4")

sheet.Cells(6,2) = Uidoc.FieldGetText("Field5")

Please, any help would be appreciated. But understand I’m not interested in any third party tools (the company won’t buy them) and I have to do this in the client.

So any help on understand how to further define/code this object would be greatly appreciated.

Thanks in advance!!!

2

Subject: Need Help with using the Object Microsoft Office Excel Charts in Client

You will find the available properties and methods in excel help.

What I have found useful when doing something similar is to record a macro in excel whilst formatting the sheet how I want it to look and then view the macro code to see how it has been set.

From what I remember the code may have constants like ChartType = PIE_CHART which you can not use in lotusscript. You have to use the applicable number like 51. You should also find these in excel and there was a notes database which I think I found in the sandbox with all the relevant constant numbers.

3

Subject: RE: Need Help with using the Object Microsoft Office Excel Charts in Client

I turned to JFreeChart and Julian Robichaux’s examples using charts.

It works terrific! You can even save the images for the user so they can add them to a powerpoint or other presentation.