Access/Microsoft Graph - Possible to control category colors via c

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

Guest

Hi:

I'd like to know if it is possible to set a color scheme for the various
categories of my stacked bar.

For example, given the following scenario: I'll need to create:

I have a table containing error codes. Each day, an employee enters any
error codes (and hours associated with the error code) associated with their
shift into the database. For example, Monday might only have Code1, Code5 and
Code6 entered into the database, while Tuesday might have Code1, Code2,
Code5, Code6 entered into the database.

While I haven't had any problem creating the bar chart, I don't like the way
that Access/Microsoft Graph changes the color scheme according to how many
error codes are in the stacked bar. Thus, if I have a graph with only 5 codes
displayed, the color scheme is different than if I had a graph with 10 codes
displayed.

Is it possible (programmatically) to create a set color scheme for my error
codes, such that "Code1" is always red, "Code2" is always blue, etc.? Could I
associate RGB value with my code table and extract them at chart creation? Is
this possible, or should I ditch MS Graph and go to a 3rd party charting
component like ChartFX or Nevron?

Thanks in advance.
 
I don't know if I answered your or a similar question before. I have created
a graph in Excel similar to the Access graph. I then turn on the macro
recorder and proceed to change the colors as needed. The code from Excel can
be applied with some modification to your Access graph. You will need to
query your data in the report section or other to determine the code. Then
set the colors as needed.
 
Hi Duane:

Thanks for your response.

I'm not sure if that would work in my situation. Basically, I'm trying to
see if it is possible to set colors (in this case, series colors of a stacked
bar) via code, based on my individual categories. For example, if my category
table has a field with a RGB value, would it be possible to use that table to
set the series colors, basically setting a standard for the colors.

Possible or should I look to 3rd Party component?

Duane Hookom said:
I don't know if I answered your or a similar question before. I have created
a graph in Excel similar to the Access graph. I then turn on the macro
recorder and proceed to change the colors as needed. The code from Excel can
be applied with some modification to your Access graph. You will need to
query your data in the report section or other to determine the code. Then
set the colors as needed.
Click to expand...
 
Back
Top