[AccessD] Working with an Excel Chart from Access (Automation) - How to Create Different Chart Types

Mark Simms marksimms at verizon.net
Wed Jun 29 16:58:04 CDT 2011


Re: powerbasic....Interesting. Can you make COM add-ins for Excel or Access
with it ?

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: Wednesday, June 29, 2011 5:02 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Working with an Excel Chart from Access
> (Automation) - How to Create Different Chart Types
>
> Here's how I create a bar chart from PowerBASIC.   From VBA would be
> the essentailly the
> same  thing :)
>
>
>
> OBJECT CALL oExcelApp.Charts.Add TO oExcelChart
> vRange = "A1:G2"
> OBJECT GET oExcelWorkSheet.Range(vRange) TO vSource
> ' Set the Chart parameters
>  vGallery   = %XlChartType.xl3DPie
>  vFormat    = 7
>  vPlotBy    = %XlRowCol.xlRows
>  vCatLabels = 1
>  vSerLabels = 0
>  vHasLegend = 1
>  vTitle     = "Sales percentages"
> ' Launch the Chart
> OBJECT CALL oExcelChart.ChartWizard(vSource, vGallery, vFormat,
> vPlotBy, vCatLabels,
> vSerLabels, vHasLegend, vTitle)
>
>
> Note: %XlChartType.xl3DPie and %XlRowCol.xlRows are predefined Numeric
> Equates
>
> --
> Stuart
>
> On 29 Jun 2011 at 14:42, Brad Marks wrote:
>
> > All,
> >
> > I have just started to experiment with "Windows Automation" code.
> >
> > I have a small Access 2007 application that uses a Record Set to
> > populate the cells in an Excel spreadsheet and then automatically
> > create a simple chart (in Excel).  This all works nicely.
> >
> > Here is the Access VBA code that adds the Chart
> >
> > XLSheet.Shapes.AddChart.Select
> >
> > I would like to be to control the "Type" of Chart that is generated
> in
> > Excel.
> >
> > I recorded an Excel Macro while in Excel to see the code that Excel
> > uses.  I then tried to use this code in Access VBA, but did not have
> > luck.
> >
> > Does anyone have an example of how to create an Excel Chart in Access
> > VBA and be able to control the Chart type?
> >
> > Thanks for your help.
> >
> > Brad
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list