Rob

Thank You very much. I loaded the XY Chart Labeler Utility and I can now
see the labels that are associated with each chart. Is the utility specific
to a single workbook or all workbooks that I open. The reason for the
question is that I create charts and pivot tables from an Access Database
through VBA automation code and I noticed that the Utility is not available
when excel is opened from within Access.

"Rob Bovey" wrote:

"hturk" wrote in message
...
How can I found out which constants apply to which charts.

Hi Harry,

Download and install my XY Chart Labeler utility from the web site below
my signature. Once installed, open Excel, go into the Visual Basic Editor,
locate the XYChartLabeler project in the Project Window and set the IsAddIn
property of its ThisWorkbook object to False.

The top table on the worksheet that you can now see back in the Excel
user interface provides a complete list of which label position constants
can be used with which chart types.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm


"Alok" wrote:

Harry

Try the constant xlLabelPositionInsideEnd

Alok

"hturk" wrote:

You are correct. What would I need to do to position the datalabels
above
each point for the columns.

Harry

"Alok" wrote:

You are probably trying to specify the position for a column chart
type. That
constant (xlLabelPositionAbove) is valid for line graph but is not
acceptable
for column chart type.

Alok

"hturk" wrote:

When I use this code that I get from Excel VBA 2002 I get an error
1004.

Dim se as Series
Dim pts as Points
Dim pt as Point

Set se = ActiveChart.SeriesCollection(2)
se.HasDataLabels = True
Set pts =se.Points
For each pt in pts
pt.datalabel.posiotion = xlLOabelPositionAbove - error 1004
happens
here.
next pt

Does anyone have an idea as to what I am doing wrong.