Set Colors For Stacked Bar Via Code using Microsoft Graph?

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

Guest

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.

Larry Mrazek
LCM Research, Inc.
 
I have the same problem. Do a search for a file Grphsm97.exe This
should give you some help. My question is how can you code custom
patterns or differnt patterns that do not have a vba code?
 
I'm still trying to find out if this is possible. Probably will call MSDN
support today (if they provide any information, I'll post to the list) to try
to get a definitive answer from Microsoft.
 
Back
Top