gnanasekaran
04-20-2009, 10:18 AM
Hi,
I have a excel chart placed in powerpoint. I wrote a macro to change the font size of data label and it works fin.But changed font was not looking correctly (for eg., if i change to 10 the font size changes and the font property is showing 10 but it looks like size 6).This is the code i used it
For x = 1 To obook.ActiveChart.SeriesCollection.Count
obook.ActiveChart.SeriesCollection(x).DataLabels.AutoScaleFont = False
obook.ActiveChart.SeriesCollection(x).DataLabels.Font.Size = chngFontSize
Next x
I have a excel chart placed in powerpoint. I wrote a macro to change the font size of data label and it works fin.But changed font was not looking correctly (for eg., if i change to 10 the font size changes and the font property is showing 10 but it looks like size 6).This is the code i used it
For x = 1 To obook.ActiveChart.SeriesCollection.Count
obook.ActiveChart.SeriesCollection(x).DataLabels.AutoScaleFont = False
obook.ActiveChart.SeriesCollection(x).DataLabels.Font.Size = chngFontSize
Next x