Custom Colors for Pivot Tables and Charts

[zorro]

Hello,

I can't seem to find a Colors property for Pivot Tables and charts, as there
is one for workbooks. I'm aiming to configure some corporate custom colors
programatically, so that the end user has them available when building a
chart or a pivot table, instead of manually plotting the RGB's.

Any ideas?

 

[Alvin Bruney - ASP.NET MVP]

have a look at the chColor object

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[zorro]

Hi Alvin,

I searched your book for that reference, as well as the help file
(OWCVBA11.CHM) and I can't seem to find such object (chColor) or property...
Is it a hidden object?

Best Regards,
Bernardo Alves

have a look at the chColor object

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hello,

I can't seem to find a Colors property for Pivot Tables and charts, as there
is one for workbooks. I'm aiming to configure some corporate custom colors
programatically, so that the end user has them available when building a
chart or a pivot table, instead of manually plotting the RGB's.

Any ideas?

 

[Alvin Bruney - ASP.NET MVP]

"... object that represents the lines on a chart. Here are the properties.
Listing 3.33 chLine Properties Usage Color Returns a chColor object. Use
this object to customize the color of the line DashStyle Returns a
DashStyleEnum. Use this property to change ..." p 107

Since these properties are polymorphic, they will work across any OWC object
include pivot tables

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi Alvin,

I searched your book for that reference, as well as the help file
(OWCVBA11.CHM) and I can't seem to find such object (chColor) or property...
Is it a hidden object?

Best Regards,
Bernardo Alves

have a look at the chColor object

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hello,

I can't seem to find a Colors property for Pivot Tables and charts, as there
is one for workbooks. I'm aiming to configure some corporate custom colors
programatically, so that the end user has them available when building a
chart or a pivot table, instead of manually plotting the RGB's.

Any ideas?

 

[zorro]

Hi Alvin,

I found the book reference and tried some stuff with the object. The point
is, I can't get a specific color to appear on the color dialog as a "Custom
Color", that is, as if I clicked the button "Add to custom colors" after
selecting an available slot.

Rephrasing my question, is there a way to configure a specific RGB, choose a
"Custom Colors" index and "click" the button "Add to custom colors" through
code?

By the way, I noticed something curious, when I do this operation manually,
let's say for a chart embedded on windows .net form, every other OWC object
on that form (pivot, spread...) displays the newly created custom color on
the color dialog. This means they share a common place (registry?...) to
store this information. Could we hack our way through?

Thanks for your help,
Bernardo Alves

"... object that represents the lines on a chart. Here are the properties.
Listing 3.33 chLine Properties Usage Color Returns a chColor object. Use
this object to customize the color of the line DashStyle Returns a
DashStyleEnum. Use this property to change ..." p 107

Since these properties are polymorphic, they will work across any OWC object
include pivot tables

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi Alvin,

I searched your book for that reference, as well as the help file
(OWCVBA11.CHM) and I can't seem to find such object (chColor) or property...
Is it a hidden object?

Best Regards,
Bernardo Alves

have a look at the chColor object

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



Hello,

I can't seem to find a Colors property for Pivot Tables and charts, as
there
is one for workbooks. I'm aiming to configure some corporate custom colors
programatically, so that the end user has them available when building a
chart or a pivot table, instead of manually plotting the RGB's.

Any ideas?

 

[Alvin Bruney - ASP.NET MVP]

The color option also takes an RGB assignment so use MS paint or some other
application to figure out the RGB and assign it to the color property.

store this information. Could we hack our way through?

I suppose, but I have no idea how.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi Alvin,

I found the book reference and tried some stuff with the object. The point
is, I can't get a specific color to appear on the color dialog as a "Custom
Color", that is, as if I clicked the button "Add to custom colors" after
selecting an available slot.

Rephrasing my question, is there a way to configure a specific RGB, choose a
"Custom Colors" index and "click" the button "Add to custom colors" through
code?

By the way, I noticed something curious, when I do this operation manually,
let's say for a chart embedded on windows .net form, every other OWC object
on that form (pivot, spread...) displays the newly created custom color on
the color dialog. This means they share a common place (registry?...) to
store this information. Could we hack our way through?

Thanks for your help,
Bernardo Alves

"... object that represents the lines on a chart. Here are the properties.
Listing 3.33 chLine Properties Usage Color Returns a chColor object. Use
this object to customize the color of the line DashStyle Returns a
DashStyleEnum. Use this property to change ..." p 107

Since these properties are polymorphic, they will work across any OWC object
include pivot tables

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hi Alvin,

I searched your book for that reference, as well as the help file
(OWCVBA11.CHM) and I can't seem to find such object (chColor) or property...
Is it a hidden object?

Best Regards,
Bernardo Alves

:

have a look at the chColor object

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



Hello,

I can't seem to find a Colors property for Pivot Tables and charts, as
there
is one for workbooks. I'm aiming to configure some corporate

custom
colors

programatically, so that the end user has them available when

building
a

chart or a pivot table, instead of manually plotting the RGB's.

Any ideas?