If you use the Chart Labeler, and use one of the default position options,
as long as the order of points hasn't changed, the label will move around
with the point. If you readjust the label position, then Excel no longer
tries to figure out where it should go automatically, so the label stays in
place.
You mentioned how you had put a label near the top and used a -100% error
bar. This is almost enough. If I want a label just below the top of the
chart, I'll put a point at around 90% of the height, assign the label to
that point, then use custom +10% and -90% error bar values.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
"tom zane" wrote in message
...
Mr. Peltier:
Hi again. I answered my own question. When I use XY Chart Labeler, and
then
change the source data, the data label STAYS PUT and does not change
position
with the data point to which it was assigned.
So, I still am trying to figure out how I can put a vertical line in at a
particular month, label what happened that month, and have that line and
label move with that month's data when I change the source data.
I thank you for your help.
"Jon Peltier" wrote:
Tom -
Excel remembers that a label goes with point X of a series, so if your
data
range still includes the point, but dynamically you've moved it to point
Y,
the label stays at X. You need to use a dummy series then for your labels
and phase-change line. I think I would add each phase change line as a
separate one-point series so that the point (no marker) coincides with
the
point you want to highlight, and the point anchors the label. Use the
label
text as the series title, and it's easier to apply to the point than
having
to use one of these addins. Then use Y error bars that will reach down to
the bottom and up to the top of the chart. It's related to this example:
http://peltiertech.com/Excel/Charts/...ertErrBar.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
"tom zane" <tom wrote in message
...
Thank you very much, but those two programs are not doing what I need:
I am entering number data per month - For example, January - 10;
February
24; March - 3; April - 15; and so on. I do this each month throughout
the
year, and I have multiple years entered.
I then construct line charts showing the data across a several-month
period.
It could be one calendar year, or it could be March 2004 through March
2005.
I need to occasionally label ONE month's data; then, whenever i change
the
source data for the next chart, that label needs to STICK WITH the
assigned
data point and move with it when the new chart is constructed.
Additionally, I need a (what I call) a phase-change line to be linked
to
the
data point and the data label. This line is a vertical line from the
data
label at the top of the chart, down through the data point to the
x-axis
at
the bottom. And this line needs to be locked (stick with) the data
point
and
label as I change the source data for a new chart.
Does this make sense? Can this be done?
"Jon Peltier" wrote:
Put the comments into another column, then use one of these free Excel
add-ins to use these cells to label the points.
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Tom Z." <Tom wrote in message
...
Using Excel, I have data numbers added in some cells. In those
cells, I
have
inserted comments. When printing the chart, I want those comments
printed
next to the plotted data point.
Can that be done? If so, how?