Exporting to Excel

Exporting to Excel

Post by Bernie Rain » Wed, 17 Oct 2001 20:26:46



Does anyone know how to access other properties in the excel worksheet
eg. Legend Text, I also want to add another series to the same chart
manually outside of the selection.  The below is the code so far...
Any Ideas please?

Worksheet3.Activate
        CellEnd="=Monthly!$A$8:$E$8,Monthly!$A$16:$E$16,Monthly!$A$24:$E$24,Monthly!$A$32:$E$32,Monthly!$A$40:$E$40,Monthly!$A$48:$E$48,Monthly!$A$56:$E$56,Monthly!$A$64:$E$64,Monthly!$A$72:$E$72,Monthly!$A$80:$E$80,Monthly!$A$88:$E$88,Monthly!$A$96:$E$96"
        Excel.Range(cellEnd).Select
        Excel.Charts.Add

        With Excel.ActiveWorkbook.ActiveChart
                .Name="Problems Monthly Chart"
                .HasTitle=True
                .HasLegend=True
                .ChartTitle.Text="Problems Statistics for Each Month"
                .ChartType= xlLineMarkers
        End With

 
 
 

Exporting to Excel

Post by bicke » Thu, 18 Oct 2001 23:35:11




Quote:> Does anyone know how to access other properties in the excel worksheet
> eg. Legend Text, I also want to add another series to the same chart
> manually outside of the selection.  

Here's the reference:
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?co...

While MSDN is hard to use, it does contain full API documentation for
every object, property and method you'll need.

--
Brian Charles Kohn (bicker)
Principal Certified Lotus Professional (R4) - Application Developer
Principal Certified Lotus Professional (R5) - Application Developer
IBM Certified Specialist - IBM WebSphere Application Server, Standard Edition

Copyright ? 2001, Brian Charles Kohn.  All Rights Reserved.
Posting in no way grants receivers any privileges, rights,
or licenses, with the exception of quoting in reply as long
as such use complies with US Law concerning Fair Use.
(This has nothing to do with regular USENET quoting and replies.)