Friday, April 11, 2008

Colors in Excel Services

If you use Excel Services inside of Microsoft Office SharePoint Server 2007 (MOSS), you may run into this little issue: Colors appear correctly when files are opened in Excel on your desktop computer, but charts and graphs turn gray and pink and magenta when viewed inside of SharePoint's Excel Services on the same desktop computer.

This is what it's supposed to look like in Excel and SharePoint:

This is what you see in SharePoint:

The reason you may see the drab colors in example 2 is something so simple that you could kick yourself: The Display settings on the server may be set to 8-bit (256 colors). The solution may be as simple as changing the display settings to b 16-bit or ideally 32-bit.

Microsoft throws this in one of it's online help pages, but you may miss it if you blink.


You should be aware that color quality settings vary on a client and server computer. (From the Control Panel, click Display to open the Display Properties dialog box, and then click the Settings tab.) There are three settings:

  • Highest (32 bit, 4 million colors).
  • Medium (16 bit, 32,000 colors).
  • Lowest (8 bit, 256 colors).

The color quality can make a difference in the clarity of the chart, especially if the colors that are used are not distinct enough for the user's current display setting. Because the chart image is created on the server computer, the setting on the server computer can limit the colors displayed in the chart, regardless of the color setting on the client computer.

/End Quote

I'd suggest you use 16-bit or 32-bit for the best results.


Warren said...

I have a coworker who keeps asking for this. We have a crappy hosted Sharepoint service so we can't use it. I shed no tears for my coworker.

Anonymous said...

I have same problem with this. And then I check my server display setting, is set on 16bit color but I still have chart color turn to gray, do you have any suggestion or idea

Joelsef said...

Did you try 32-bit? Ideally you'd run the display settings at 32-bit to get the full gamut of colors.

Anonymous said...

Wow! this has been a nightmare for us.
I cannot believe this was the solution.

After reading this site, we found out that the display setting was changing to the lowest quality every time we logged on remotely.

Thanks mate!

Anonymous said...

how about turned into 8 bit ,because i change 8 bit to 32 bit and i click apply,when i restart it, it turns to 8 bit again???

Joelsef said...

Are you making the change as a server administrator on the server?

Off the top of my head, I can't think why else it may change back.

Karthika Shree said...

Great post! I am see the programming coding and step by step execute the outputs.I am gather this coding more information. It's helpful for me my friend. Also great blog here with all of the valuable information you have.
Sharepoint Training in Chennai

Praylin S said...

Awesome post! Thanks for sharing with us.
Unix Training in Chennai | Unix Shell Scripting Training in Chennai | Unix Course in Chennai | Unix Certification Courses | LINUX Training in Chennai | Excel Training in Chennai | Wordpress Training in Chennai