MS graph

[John]

i've found that MS graph doesn't allow for very user-
friendly formatting of graphs...i have a few problems.

#1. no matter what the order of the categories on the x
axis (bar graph), the legend seems to order them
differently (it appears to do it reverse-alphabetically) -
any way to change that?

#2 - is there any way to see the REAL data in MS graph
and not the stupid sample data (Sales by
region..blah..blah)??

Any help would be much appreciated! Thanks!
John

 

[Duane Hookom]

Copy your graph to a form and set the Enabled to Yes and Locked to No. Then
view the form and double click the graph. When you go back to design view,
you should see your data. The Row Source datasheet generally determines the
order displayed in the graph control.

When you get it like you want, copy it back to the report.