LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Data Labels Macro

This has also been posted on the Mr. Excel boards but has not generated any
response. I am working on modifing a chart using VB. I recorded the macro
at first and got the following lines of code:

ActiveChart.SeriesCollection(2).Points(1).DataLabe l.Select
Selection.AutoScaleFont = True
With Selection.Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 10
.ColorIndex = 2
.Background = xlTransparent
End With
With Selection
.Position = xlLabelPositionInsideBase
End With

When I try to rerun this code without any modification, I get the following
error:

Select method of DataLabels class failed.

I looked on a few boards and modified the code to look like this:

ActiveChart.SeriesCollection (1)
.HasDataLabels = True
.ApplyDataLabels Type:=xlValue
Selection.AutoScaleFont = True
With .DataLabels.Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 10
.ColorIndex = 2
End With
With .DataLabels
.Position = xlLabelInsideBase
End With

When i run this code, I get this error:

Invalid or unqualified reference

Is there some reference library that I need to select or something I need to
change in the code? Any ideas would be greatly appreciated.

Kristin
 
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
Macro Auto-update of data labels [email protected] Excel Worksheet Functions 0 August 7th 07 04:17 PM
is it possible that the data values shown on the data labels be in a duifferent range tweety127[_18_] Excel Programming 0 June 7th 06 10:16 PM
Setting hover data labels to cells other than source data Darren Charts and Charting in Excel 1 January 24th 06 10:20 AM
Setting hover data labels to cells other than source data Darren Excel Discussion (Misc queries) 0 January 24th 06 08:31 AM
Macro to add labels to data points in an xy scatter chart Scott Wagner Charts and Charting in Excel 2 December 17th 05 01:46 AM


All times are GMT +1. The time now is 12:37 AM.

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"