Welcome to SPN

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

Sign Up Now!

Charts

Discussion in 'Information Technology' started by Raymond, Jul 28, 2006.

Tags:
  1. Raymond

    Raymond
    Expand Collapse
    Guest

    I have created a chart to show the number of records per month but would like
    to see only the last 12 months records.
    Is it also possible to show two lines on a chart. One show last yrs
    performance per month and then the current year to date?
    --
    Raymond
     
  2. Loading...

    Similar Threads Forum Date
    Arts/Society Jay Sean/ Kamaljeet Singh Hits Top of U.S. Pop Charts Language, Arts & Culture Oct 29, 2009
    Sikh News British Sikh singer is a huge success in mainstream British charts Breaking News Nov 2, 2004

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    If you output 2 separate queries to 2 separate Excel ranges, you can
    certainly base a chart on that. Here's an example of Excel automation:

    http://www.mvps.org/access/modules/mdl0006.htm

    You may also want to lookup "OutputTo" and "TransferSpreadsheet" in the
    Access help files.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Raymond" <Raymond@discussions.microsoft.com> wrote in message
    news:3BFB8992-7C92-4939-BE5B-E454804D2B11@microsoft.com...
    > I have created a chart to show the number of records per month but would

    like
    > to see only the last 12 months records.
    > Is it also possible to show two lines on a chart. One show last yrs
    > performance per month and then the current year to date?
    > --
    > Raymond
     

Share This Page