Set font color of SeriesCollection Caption

[Michael Weiss]

I need to change the color of the text in the caption for
a series in an OWC 10 chart. So far I have:
Set cht = cspace.charts(3)
With cht
..SeriesCollection(0).Caption = "CPM"
..SeriesCollection(0).Caption.Font.Color = "#336699"
End With

No matter what I try on the second line referencing the
SeriesCollection(0) above I can not seem to get to the
color of the text in the caption to set it. Any help
would be greatly appreciated.
Thank you,
Michael

 

[Alvin Bruney [MVP]]

do you mean the color of the caption that appears in the legend? Or are you
talking about something else? Attach an image of what exactly you want to
color if possible.

 

[Michael Weiss]

Hi Alvin,
I can't seem to get an image so the best I can do is tell
you that it is the series label caption font color that I
need to change...hope that helps describe it better!
Thank you,
Michael

-----Original Message-----
do you mean the color of the caption that appears in the legend? Or are you
talking about something else? Attach an image of what exactly you want to
color if possible.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

I need to change the color of the text in the caption for
a series in an OWC 10 chart. So far I have:
Set cht = cspace.charts(3)
With cht
.SeriesCollection(0).Caption = "CPM"
.SeriesCollection(0).Caption.Font.Color = "#336699"
End With

No matter what I try on the second line referencing the
SeriesCollection(0) above I can not seem to get to the
color of the text in the caption to set it. Any help
would be greatly appreciated.
Thank you,
Michael

.

 

[Alvin Bruney [MVP]]

in that case you need to adjust the datalabels object
the caption is not customizable in that way

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi Alvin,
I can't seem to get an image so the best I can do is tell
you that it is the series label caption font color that I
need to change...hope that helps describe it better!
Thank you,
Michael

-----Original Message-----
do you mean the color of the caption that appears in the legend? Or are you
talking about something else? Attach an image of what exactly you want to
color if possible.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

I need to change the color of the text in the caption for
a series in an OWC 10 chart. So far I have:
Set cht = cspace.charts(3)
With cht
.SeriesCollection(0).Caption = "CPM"
.SeriesCollection(0).Caption.Font.Color = "#336699"
End With

No matter what I try on the second line referencing the
SeriesCollection(0) above I can not seem to get to the
color of the text in the caption to set it. Any help
would be greatly appreciated.
Thank you,
Michael

.