Jump to content

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here. X
X


Photo

Color management for Excel Charts

Excel Color Chart

  • Please log in to reply
6 replies to this topic

#1 water

water

    ?

  • MVPs
  • 15,526 posts

Posted 10 December 2011 - 08:12 PM

Is anyone familiar with the color management of Excel with charts? Is there any good reading you can recommend?
MSDN just gives a listing of all objects, methods and properties but no explanation how they are related and how to use them?
Properties like Color, ColorIndex, SchemeColor, ObjectThemeColor, ThemeColor confuse me a bit.

Any hint is greatly appreciated.

Edited by water, 10 December 2011 - 08:16 PM.

UDFs:
Active Directory (NEW 2014-07-21 - Version 1.4.1.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki







#2 taietel

taietel

    I'm the third from the left...

  • Active Members
  • PipPipPipPipPipPip
  • 726 posts

Posted 10 December 2011 - 08:28 PM

water, you can find some usefull stuff here (check the pdf link).

#3 water

water

    ?

  • MVPs
  • 15,526 posts

Posted 10 December 2011 - 08:46 PM

Taietel, thanks for the reply.
The pdf is a quite good reading and gives a lot of information what color to use for which purpose.
Where I need information is how to use the COM objects, methods and properties.

Color: lets you specify the color as red, green, blue values
ColorIndex: lets you specify the color as a number from 0-56 of the current color palette.
SchemeColor: When I want to color a fill I have to use SchemeColor (values from 0-56) but it seems to use a different color palette because I get different colors compared to ColorIndex.

So I need a good reading explaining how to use the different methods and properties. It should explain Excel 2007 and Excel 2010.

Thanks

Edited by water, 22 March 2013 - 11:39 PM.

UDFs:
Active Directory (NEW 2014-07-21 - Version 1.4.1.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

#4 taietel

taietel

    I'm the third from the left...

  • Active Members
  • PipPipPipPipPipPip
  • 726 posts

Posted 10 December 2011 - 08:49 PM

Oh, now I get it. Look here: http://dmcritchie.mvps.org/excel/colors.htm

#5 water

water

    ?

  • MVPs
  • 15,526 posts

Posted 10 December 2011 - 09:10 PM

Thanks a lot! Exactly what I need to start. Will keep me busy for quite some time.
Do you know of something similar for Excel 2007 and later? I know that Microsoft made big changes to the charting engine after Excel 2003. Charts created in Excel 2003 or earlier look completely different in Excel 2007 (in respect of colors). Themes were added so there are a lot of possibilities in the newer versions of Excel.

The findings will go into our ExcelChart UDF. As soon as we understand how colors are handled by Excel 2007 and Excel 2010 we will release the first alpha of our UDF.
UDFs:
Active Directory (NEW 2014-07-21 - Version 1.4.1.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

#6 taietel

taietel

    I'm the third from the left...

  • Active Members
  • PipPipPipPipPipPip
  • 726 posts

Posted 10 December 2011 - 09:17 PM

I've tested this with Excel 2010 and it's ok (bar chart). See if it helps.

#7 water

water

    ?

  • MVPs
  • 15,526 posts

Posted 10 December 2011 - 09:52 PM

Thanks, I will give it a try tomorrow.
UDFs:
Active Directory (NEW 2014-07-21 - Version 1.4.1.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki





Also tagged with one or more of these keywords: Excel, Color, Chart

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users