ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is color indexing dependent upon the display (https://www.excelbanter.com/excel-programming/383338-color-indexing-dependent-upon-display.html)

Lon Sarnoff

Is color indexing dependent upon the display
 
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 laptops operating system?

Jason

Is color indexing dependent upon the display
 
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 laptops operating system?


Tom Ogilvy

Is color indexing dependent upon the display
 
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 laptops operating system?


Tom Ogilvy

Is color indexing dependent upon the display
 

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 laptops operating system?


Lon Sarnoff

Is color indexing dependent upon the display
 
Thanks for the reference. Through it I discovered that the assignment of a
color to a color index can be modified through the ToolsOptionsColors
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 laptops operating system?



All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com