RE: [MS_AccessPros] Re: Changing series colors on a graph

Please reply with the SQL view of your cross tab query and tell us what is missing.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: jfakes@rocketmail.com
Date: Tue, 28 Jun 2011 13:39:49 +0000
Subject: [MS_AccessPros] Re: Changing series colors on a graph

I am generating the charts from a crosstab query. I do not know SQL nor do I know how I would record what needs to be done in Excel (I have recorded macros, i just don't know what needs to be done).

Can you send me some sample code or some idea of how I could set the colors? Again, I don't know SQL or VBA. I'm trying to get some VBA training as I think it would help out a lot.

Thanks for your help, I really need it.

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:

>

>

> I thought I had replied earlier regarding two possible solutions:

> 1) Assure that all years are generated using some SQL statement tricks

> 2) use code set the colors. I typically use the macro recorder in Excel to write the code and then paste it into Access. You need to change a couple lines to reference the chart control.

>

> Duane Hookom

> MS Access MV

>

>

>

>

> To: MS_Access_Professionals@yahoogroups.com

> From: jfakes@...

> Date: Mon, 27 Jun 2011 18:03:07 +0000

> Subject: [MS_AccessPros] Re: Changing series colors on a graph

>

>

>

>

>

>

> I'm still looking for some guidance on this issue. Does anyone know how to set these colors and keep them the same?

>

> Thanks.

>

> --- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@> wrote:

> >

> > I have a report that has a graph on it. The user generates at least 50 different graphs using this report. The graphs display data from 2007-2010. However not all data is available for all years.

> >

> > What is happening is if data is available for all 4 years, the graph displays properly using color coding for each year (red for 2010, green for 2009, tan for 2008, and purple for 2007).

> >

> > However, if data is missing from say 2007-2008, the color of the bars randomly change (could be red for 2007, and yellow for 2008).

> >

> > The user wants all graphs to display using the standard colors. I don't know SQL or VBA so I cannot figure out how to set the standard numbers as they always change (a known MS Access issue).

> >

> > Can anyone help me figure out how to resolve this issue?

> >

> > Here is the process:

> >

> > 1. User opens report and enters graph desired XYZ for example.

> > 2. The report opens and the user can see the graph.

> >

>

>

>

>

>

>

> [Non-text portions of this message have been removed]

>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/