LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
TG TG is offline
external usenet poster
 
Posts: 8
Default Apply different color to datalabels

I have a code that adds series to a chart.
I want to set the Datalabel.Interior.ColorIndex, but for some reason
the ClorIndex is not applyed to the DataLabel..

Any suggestion on why? Or how can i do this?

My current code includes:

With Sheets("Chart").SeriesCollection.NewSeries
.Name = Name
.XValues = XValue
.Values = YValue
.MarkerSize = 5
.ApplyDataLabels
.DataLabels.Interior.Pattern = xlSolid
.DataLabels.Interior.ColorIndex = C
.DataLabels.Border.ColorIndex = 1
.DataLabels.Font.Size = 7
.DataLabels.Position = xlCenter
.DataLabels.Orientation = 45
.DataLabels.ShowSeriesName = True
.DataLabels.ShowValue = False
End With

(where C is set to a valid value using a Select Case loop.)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Apply different color themes to worksheets withing a workbook kdarrow Excel Discussion (Misc queries) 2 August 26th 13 10:09 PM
Apply color of one cell to other Tigerxxx Excel Discussion (Misc queries) 3 June 15th 09 08:30 AM
How to apply different color on different columns and legends easily? [email protected] Charts and Charting in Excel 1 March 19th 07 09:04 AM
HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT conditional format Excel Worksheet Functions 2 July 30th 06 05:37 PM
How do I apply color in cells ..color now shown only in print prev bonadimi Excel Worksheet Functions 1 April 25th 06 07:34 PM


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"