My application has produced several hundred charts. They display very nicely
on my desktop monitor. I have transferred the charts to a laptop to be used
in a training session and the display of those colors is quite different, and
causes the chart to be much less legible. I do not want to have to
regenerate the charts. Is there some way to modify how a given ColorIndex is
displayed by the laptop’s operating system?

Yes, using color index numbers can change based on different OS. To ensure
that colors are always the same, use the RGB property of the color index.

"Lon Sarnoff" wrote:

> My application has produced several hundred charts. They display very nicely
> on my desktop monitor. I have transferred the charts to a laptop to be used
> in a training session and the display of those colors is quite different, and
> causes the chart to be much less legible. I do not want to have to
> regenerate the charts. Is there some way to modify how a given ColorIndex is
> displayed by the laptop’s operating system?

Not that I am aware of, but make sure the laptop doesn't have some disability
setting in place in the windows control panel.

--
Regards,
Tom Ogilvy



"Lon Sarnoff" wrote:

> My application has produced several hundred charts. They display very nicely
> on my desktop monitor. I have transferred the charts to a laptop to be used
> in a training session and the display of those colors is quite different, and
> causes the chart to be much less legible. I do not want to have to
> regenerate the charts. Is there some way to modify how a given ColorIndex is
> displayed by the laptop’s operating system?

http://www.mvps.org/dmcritchie/excel/colors.htm

--
Regards,
Tom Ogilvy


"Jason" wrote:

> Yes, using color index numbers can change based on different OS. To ensure
> that colors are always the same, use the RGB property of the color index.
>
> "Lon Sarnoff" wrote:
>
> > My application has produced several hundred charts. They display very nicely
> > on my desktop monitor. I have transferred the charts to a laptop to be used
> > in a training session and the display of those colors is quite different, and
> > causes the chart to be much less legible. I do not want to have to
> > regenerate the charts. Is there some way to modify how a given ColorIndex is
> > displayed by the laptop’s operating system?

Thanks for the reference. Through it I discovered that the assignment of a
color to a color index can be modified through the Tools>Options>Colors
setting. This allows me to change all of the charts' backgrounds for the
many hundreds of charts contained within the few number of workbooks I had
generated. It saved me much work.

"Tom Ogilvy" wrote:

>
> http://www.mvps.org/dmcritchie/excel/colors.htm
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Jason" wrote:
>
> > Yes, using color index numbers can change based on different OS. To ensure
> > that colors are always the same, use the RGB property of the color index.
> >
> > "Lon Sarnoff" wrote:
> >
> > > My application has produced several hundred charts. They display very nicely
> > > on my desktop monitor. I have transferred the charts to a laptop to be used
> > > in a training session and the display of those colors is quite different, and
> > > causes the chart to be much less legible. I do not want to have to
> > > regenerate the charts. Is there some way to modify how a given ColorIndex is
> > > displayed by the laptop’s operating system?