How To Make Two Graphs Using Same Color Legend?

[Guest]

I have two graphs that I am using on a report. Both graph or charts have the
same data and plot the graph just a little different on the same report.

I used the wizard to create 2 graph report and put them on the same report.

How can I make the color legend on both chart the same???? I have not idea
on how to do this. Is there a way to do that via VBA code??? I do know VBA
code.

Any help is deeply appreciated.

Gary

 

[SA]

Gary:

Yes, you can change the color of individual bars either in the standard
design mode by selecting a specific bar, or via VBA code at run time. If
you want an example of the VBA to get to a bar's color, then stop by our web
and look in the Code and Design tips under reports and at the topic "Solving
Common Problems with Graphs in Access Reports", for the last item discussed.
That should get you to a starting point.