I am using RB Prof. on Windows XP Prof.
I get the data from Oracle on a Unix server, store it in an array, add it
to a new EXCEL worksheet, and then create a 3-dimensional linear graph
using the following code which I found in an example project:
Chart = Book.Charts.Add
Chart.ChartType = -4101
Chart.SetSourceData Book.Sheets("Data for Graph").Range(Rng),2
Chart.Location 2, "Data for Graph"
Excel.ActiveSheet.Shapes("Chart 1").IncrementTop 90.0
I am searching for documentation or examples of how to change the ChartType
(-4101) to other chart types. I would also like to find documentation for
commands similar to Excel.ActiveSheet.Shapes("Chart 1").IncrementTop 90.0
in order to move the graph left or right on the page. And, I would like to
find documentation or examples to change chart title, series, legend, and
category values.
The reference manual says to use the help for VBA in EXCEL, but my EXCEL in
Office 10 on XP writes macros that simply will not work in RB. All the
examples I have found are written for Visual Basic, and I don't know the
proper syntax to make them work in RB. There must be RB documentation or
examples somewhere that can help me learn how to do this.
Can anyone help?
Thank you.
Ruth Watkins
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|