Results 1 to 2 of 2

Thread: Graph Order

  1. #1
    Join Date
    Apr 2003

    Unanswered: Graph Order

    Quick question. I am having a problem with a line graph. It is plotting two sets of data on a quarterly basis. The problem is that their are three graphs on the report and the order of the legend or the representing colors are not the same on each graph. Basically I want the last record in the legend to be first and to be the color of the first. I have manually changed them, I have changed the sorting in the queries that drive the chart and have re-ordered the datasheet, however it seems to just randomly decide how to plot and how to assign the colors.

    Any thoughts would be great.

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    Open the report in design view, right-click on the graph and choose properties. Right-click on Row Source (all or data tab) and choose zoom. I have found that this is the best place to edit graphs in access.

Posting Permissions

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