Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Programmatically created/manipulate graphs in access

Discussion in 'Information Technology' started by millie.patel@gmail.com, Jul 28, 2006.

  1. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    Hi all,

    I am trying to programmatically create a chart in access; is there an
    equivalent of the ChartObjects (in Excel) for Access?

    Thanks,

    Millie
     
  2. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Even though Access uses the same COM object for charting as Excel, the
    implementation is better in Excel. I usually prefer to export the data to
    Excel using automation and manipulate my charts there. This ought to give
    you some idea of how to do it:

    http://www.mvps.org/access/modules/mdl0007.htm
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    <millie.patel@gmail.com> wrote in message
    news:1151441201.629677.79350@u72g2000cwu.googlegroups.com...
    > Hi all,
    >
    > I am trying to programmatically create a chart in access; is there an
    > equivalent of the ChartObjects (in Excel) for Access?
    >
    > Thanks,
    >
    > Millie
    >
     
  3. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    thanks for your help arvin :)

    Arvin Meyer [MVP] wrote:
    > Even though Access uses the same COM object for charting as Excel, the
    > implementation is better in Excel. I usually prefer to export the data to
    > Excel using automation and manipulate my charts there. This ought to give
    > you some idea of how to do it:
    >
    > http://www.mvps.org/access/modules/mdl0007.htm
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > <millie.patel@gmail.com> wrote in message
    > news:1151441201.629677.79350@u72g2000cwu.googlegroups.com...
    > > Hi all,
    > >
    > > I am trying to programmatically create a chart in access; is there an
    > > equivalent of the ChartObjects (in Excel) for Access?
    > >
    > > Thanks,
    > >
    > > Millie
    > >
     

Share This Page