LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Annotate a point on a chart

A more complicated approach would use a static range as the data label
source range. You would use a lookup table that had the date and desired
label, and in the data label source range, you would use a lookup using the
date corresponding to the cell in the data label range to find the
corresponding label in the lookup table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Marvin" wrote in message
...
Thank you, but that clearly does not meet my objective.

"Jon Peltier" wrote:

You could use a data label, except the data label is linked to a point
with
a given index. In other words, if you added a data label to November, the
11th point, if you then delete January, November becomes the 10th point,
and
the label stays with the 11th point.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Marvin" wrote in message
...
Is there any way to annotate a point on a chart, and then have that
annotation always move with the point without further interaction?

As an example, I would like to add a note to a data point for November
2006.
My data spans the last 12 months. Each month, I delete the first point
in
the series, and add a new point at the end.

Thanks.







 
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
change point size of all points in an xy chart kilter Charts and Charting in Excel 4 May 11th 23 03:43 AM
regarding allocation of chart series point colors David Charts and Charting in Excel 2 October 27th 06 09:18 AM
how to produce horizontal line chart of point est & 95% ci's w98user Charts and Charting in Excel 2 November 9th 05 11:04 AM
How to extend a single point into a line in a chart? sibimelvin Charts and Charting in Excel 1 June 22nd 05 03:52 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM


All times are GMT +1. The time now is 01:18 PM.

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"