Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can this be done Graphs/MS Query (2003)

    I have been asked to produce an workbook of reports. The managers want it in Excel even though I program in Access.
    An Access database will generate 6 tables for the data.
    The tables contain historical data for 51 different models of machines.
    The Excel workbook will have 1 worksheet for each model.
    Each worksheet will 5 graphs and a table based on the Access data.
    The graphs show historical data(12 columns with each column being 3 months worth of data)
    I've played with MS Query and can generate the table from the Access data and use a cell value for the parameter in the query to get data for the correct model shown.
    Graph Questions:
    1. Can Graphs be built directly from MS Query? I didn't see any way to do this.
    2. If so, can blank graphs be placed on the sheets and MS Query be used with parameters to populate without
    having to create all 51 pages manually.
    3. Should I try harder to convince them to use Access.
    Thanks,
    Scott

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can this be done Graphs/MS Query (2003)

    1. Not as far as I know. But a pivot table can be based directly on Access data without importing the data into Excel. So if your charts can be based on a pivot table, you might be able to simplify things. Can't really tell, since the charts in the workbook you attached are based on data in another workbook.
    2. See 1.
    3. Yes. You could probably create one report in Access to cover all 51 models.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can this be done Graphs/MS Query (2003)

    Hans,
    Thanks for the reply.
    I was hoping that was the case.
    I'll start working on MS Accessing the managers.

    Thanks for all your contributions to the board. It makes a lot of our lives less stressfull.
    Scott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •