Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2005
    Posts
    30

    Unanswered: Scrolling Graphs

    Does any one have any idea on how to create a scrolling graph on an access form. I have 5 years of values per month and I currently display 2 years. I would like to be able to scroll back and forth thru all the values and have them display on the chart. I found many examples in Excel but none for Access. Any help would be greatly appreciated.

    Thanks
    Darejamr

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    a trend graph may be what you are looking for
    youmayhave to buy a suitable controlm there may evenb be one free on t'net

    if its in excel.. just a thought why not dump the data into Excel, or open an instance of excel within Access
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2005
    Posts
    30
    What I have is a graph of values for 5 years by month. The graph displays the top 24 values by date. I have a scroll bar control below it. I would like to be able to display any range of dates in the table by moving the scroll bar.

    Thanks
    Darejamr

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    can you get this graph to work in Excel
    if so you have two options
    export the data to (or import it into) an excel spreadsheet

    OR create an isntance of Excel within your Access application
    OR try to find a trend chart control.. they do exist...
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Not sure about the scrolling bit, but this may get you going.

    Set up a form (frmGraphCrit) with a subform (frmGraph). Create a query to use as the data source for your graph and use controls (text or combo boxes) from frmGraphCrit as criteria for the date. Give the user a button to refresh the graph or have it refresh when the criteria controls change.

Posting Permissions

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