[AccessD] How to Change Access 2007 Chart Colors with VBA

Hi Brad,

I've never tried this myself, but I did a search on 'ms graph vba', and got
many promising hits.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Saturday, September 04, 2010 8:29 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] How to Change Access 2007 Chart Colors with VBA

All,

I would like to learn how to change various Chart attributes with VBA.

I set up a new chart (Report Design Tab / Insert Chart).

I can use the built-in tools to change the Chart colors manually.

I would like to learn how to change things via VBA code.

The report name is Report1.  The chart name is Chart0.

I would like to start by leaning how to change the color of the "Chart
Area", the "Plot Area" and the "Data Series" with VBA code.

I have surfed the web trying to find an example, but no luck after many
tries.

An example of how to do this would be most appreciated.

Thanks,
Brad
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com