Overflow on .Top = .Top + x

**Doctorul** · 05-16-2009, 09:58 AM

Hello guys.

I'm trying to write some code that would basically:
1) show the label for one defined point only and hide the labels for all the rest
2) define how the label should be displayed on the graph

The problem is I get an "overflow" error at .Top = .Top + 6 and I can't understand why.

In fact I run the macro once, it works like it should, then when I try to redefine de point I get the "overflow" error. I hit "reset" in the VB Editor, then run the macro again and it works. But still, what's wrong?

Please Login or Register  to view this content.

**Andy Pope** · 05-16-2009, 10:32 AM

can you post example workbook with chart and data

**Doctorul** · 05-16-2009, 03:10 PM

There you go Andy Pope.

Just a basic example, a "draft" I'm working on for now.

**Andy Pope** · 05-17-2009, 09:38 AM

I can not get your example to generate an error.

**Doctorul** · 05-17-2009, 12:41 PM

Could it be a setting in my Excel?!
I also noticed that it won't save the position of the label. Each time I open the file, the label is placed to the right no matter what.

Anyway, thanks a lot Andy Pope. I guess the problem is solved since it can't be reproduced.

**Andy Pope** · 05-18-2009, 04:23 AM

Maybe not a setting as such but it does sound like your workbook maybe corrupt.

Is the purpose of the code simply to move the data label nearer to the data point?

**Doctorul** · 05-19-2009, 03:29 AM

Yes and also to display the data label for one defined point only.

I'm using some similar code at work where everything is ok, but I've tried improving it at home on my Office 2007 and it's here where the problems apeared.

**Andy Pope** · 05-19-2009, 05:00 AM

How about a non vba solution?

This uses a dummy series that only plots a single point.
The dummy series name is a combination of the Y values and a Linefeed.

This allows you to position the data label centered over the data point but because of the 2 lines in the data label the Y value appears above the data marker.