Does anyone know a way to keep the pointer of a callout assigned to a point
in a graph? I am trying to add additional data points to graphs and my
callouts don't follow the point. Is there a way to do this without moving
the call out every time?

You could use a datalabel instead of a callout. Not the same visual
effect but...

If you do decide to go that route, you may want to use Bovey's XY
Chartlabeler (www.appspro.com) or Walkenbach's ChartTools (www.j-
walk.com).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBTZXh0b24=?=" <Paul
says...
Does anyone know a way to keep the pointer of a callout assigned to a point
in a graph? I am trying to add additional data points to graphs and my
callouts don't follow the point. Is there a way to do this without moving
the call out every time?

Tushar,

Thanks for your reply. The data labels seem to want to show data for more
than a single point. I am using these callouts to record information on
control charts where there are assignable causes for data points outside of a
normal distribution. I have tried both programs without much success.

Paul

"Tushar Mehta" wrote:

You could use a datalabel instead of a callout. Not the same visual
effect but...

If you do decide to go that route, you may want to use Bovey's XY
Chartlabeler (www.appspro.com) or Walkenbach's ChartTools (www.j-
walk.com).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBTZXh0b24=?=" <Paul
says...
Does anyone know a way to keep the pointer of a callout assigned to a point
in a graph? I am trying to add additional data points to graphs and my
callouts don't follow the point. Is there a way to do this without moving
the call out every time?

Suppose your data are in A2:B{whatever}. Enter the notes you want in
C2:C{whatever} for only those points for which you want said notes.
Now, set the datalabels to C2:C{whatever}.

Yes, all points will have datalabels attached to them. But they will
be empty with the exception of what you enter.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBTZXh0b24=?=" <Paul
says...
Tushar,

Thanks for your reply. The data labels seem to want to show data for more
than a single point. I am using these callouts to record information on
control charts where there are assignable causes for data points outside of a
normal distribution. I have tried both programs without much success.

Paul

"Tushar Mehta" wrote:

You could use a datalabel instead of a callout. Not the same visual
effect but...

If you do decide to go that route, you may want to use Bovey's XY
Chartlabeler (www.appspro.com) or Walkenbach's ChartTools (www.j-
walk.com).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBTZXh0b24=?=" <Paul
says...
Does anyone know a way to keep the pointer of a callout assigned to a point
in a graph? I am trying to add additional data points to graphs and my
callouts don't follow the point. Is there a way to do this without moving
the call out every time?

Tushar,

Sorry to be a pest. One more twist to this process. We are adding data
all the time. So, I am change the source data range to delete older data
and then include new data. When I do this, it seems the range of the data
labels doesn't move. Can I get these to move automatically or update the
range of data label somewhere? It seems that I can only delete the old
labels and create a new one.

Paul

"Tushar Mehta" wrote:

Suppose your data are in A2:B{whatever}. Enter the notes you want in
C2:C{whatever} for only those points for which you want said notes.
Now, set the datalabels to C2:C{whatever}.

Yes, all points will have datalabels attached to them. But they will
be empty with the exception of what you enter.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBTZXh0b24=?=" <Paul
says...
Tushar,

Thanks for your reply. The data labels seem to want to show data for more
than a single point. I am using these callouts to record information on
control charts where there are assignable causes for data points outside of a
normal distribution. I have tried both programs without much success.

Paul

"Tushar Mehta" wrote:

You could use a datalabel instead of a callout. Not the same visual
effect but...

If you do decide to go that route, you may want to use Bovey's XY
Chartlabeler (www.appspro.com) or Walkenbach's ChartTools (www.j-
walk.com).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBTZXh0b24=?=" <Paul
says...
Does anyone know a way to keep the pointer of a callout assigned to a point
in a graph? I am trying to add additional data points to graphs and my
callouts don't follow the point. Is there a way to do this without moving
the call out every time?

How are you making these changes to the chart data? If
programmatically, enhance the code to redo the data labels assignment.
If by hand, add one more step to redo the needful.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Tushar,

Sorry to be a pest. One more twist to this process. We are adding data
all the time. So, I am change the source data range to delete older data
and then include new data. When I do this, it seems the range of the data
labels doesn't move. Can I get these to move automatically or update the
range of data label somewhere? It seems that I can only delete the old
labels and create a new one.

Paul

"Tushar Mehta" wrote:

Suppose your data are in A2:B{whatever}. Enter the notes you want in
C2:C{whatever} for only those points for which you want said notes.
Now, set the datalabels to C2:C{whatever}.

Yes, all points will have datalabels attached to them. But they will
be empty with the exception of what you enter.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBTZXh0b24=?=" <Paul
says...
Tushar,

Thanks for your reply. The data labels seem to want to show data for more
than a single point. I am using these callouts to record information on
control charts where there are assignable causes for data points outside of a
normal distribution. I have tried both programs without much success.

Paul

"Tushar Mehta" wrote:

You could use a datalabel instead of a callout. Not the same visual
effect but...

If you do decide to go that route, you may want to use Bovey's XY
Chartlabeler (www.appspro.com) or Walkenbach's ChartTools (www.j-
walk.com).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBTZXh0b24=?=" <Paul
says...
Does anyone know a way to keep the pointer of a callout assigned to a point
in a graph? I am trying to add additional data points to graphs and my
callouts don't follow the point. Is there a way to do this without moving
the call out every time?