to change the colour of the data labels in a chart

[saji]

hi excel experts
I have created a chart to graphically view the temperature of 4 objects for 30 days using vba code. I have assigned 30 dates to the X axis and on the Y axis temperatures from 1 degree to 10 degree is marked. I have used a line graph to view the ups and downs of the temperature for the 4 objects everyday for 30 days.

After creating the chart I formatted the plot area and chart area and made its color black. Once the chart area became black the dates and temperature values became invisible because the font color of both are black too. Now what I want is a code to make those data labels (I am not sure those are called 'data labels' or not) white or some other color other than black.

your valuable help is much appreciated
thank yu
saji

[coreytroy]

Please Login or Register  to view this content.

[saji]

hi coreytroy

i tried with the solution you have posted; but it showing error.

In line1 I have substituted "Chart 1" with "Temp1" (the name of my chart) & it is working

In the next line I can't figure out how modify series of data labels. Can you please explain?
In the worksheet the Dates are given in Range A2:A31

thnk u