Printing a graph in pattern or solid colour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have an access 2002 report that includes a mircorsoft
graph chart. The chart is in colour and great when
printed on a colour printer. But when the report is faxed
it is meaningless as the colours cannot be defined. The
client wishes to stay with the colours as they are but
have the graph printed in pattern when needed. Is there
any way of changing the style/colour/pattern of the bars
on the graph thru access code.
 
Annon:

Yes, there's a way to change the colours of the chart bars or pie pieces on
the fly at run time. You might have a form that has an option group for
printing or faxing that the report's code could reference when it is run to
determine what colors to use.

The element that you need to address in code is the
DataSeries.Points(i).interior.Color element and the
DataSeries.Points(i).interior.Fill element

Stop by our web and look in the Code and Design Tips area in the Reports sub
area, and you'll find tips to work with general Graph issues; one of those
tips (#4) shows code on how to address the various data elements discussed
above. That, along with the Graph help file under programming information,
should get you started.
 
Thanks, that works great but am now having problems
changing the colour inside the legend key. Is there
anywhere I can look for help with this. Thanks.
 
Back
Top