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.
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.