software

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?

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, appspro.com
John Walkenbach's Chart Tools, j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Tom Z.quot; lt;Tom gt; wrote in message
...
gt; Using Excel, I have data numbers added in some cells. In those cells, I
gt; have
gt; inserted comments. When printing the chart, I want those comments printed
gt; next to the plotted data point.
gt;
gt; Can that be done? If so, how?
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?

quot;Jon Peltierquot; wrote:

gt; Put the comments into another column, then use one of these free Excel
gt; add-ins to use these cells to label the points.
gt;
gt; Rob Bovey's Chart Labeler, appspro.com
gt; John Walkenbach's Chart Tools, j-walk.com
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;Tom Z.quot; lt;Tom gt; wrote in message
gt; ...
gt; gt; Using Excel, I have data numbers added in some cells. In those cells, I
gt; gt; have
gt; gt; inserted comments. When printing the chart, I want those comments printed
gt; gt; next to the plotted data point.
gt; gt;
gt; gt; Can that be done? If so, how?
gt;
gt;
gt;

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:

peltiertech.com/Excel/Charts/...ertErrBar.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;tom zanequot; lt;tom gt; wrote in message
...
gt; Thank you very much, but those two programs are not doing what I need:
gt;
gt; I am entering number data per month - For example, January - 10; February
gt; 24; March - 3; April - 15; and so on. I do this each month throughout the
gt; year, and I have multiple years entered.
gt;
gt; I then construct line charts showing the data across a several-month
gt; period.
gt; It could be one calendar year, or it could be March 2004 through March
gt; 2005.
gt;
gt; I need to occasionally label ONE month's data; then, whenever i change the
gt; source data for the next chart, that label needs to STICK WITH the
gt; assigned
gt; data point and move with it when the new chart is constructed.
gt;
gt; Additionally, I need a (what I call) a phase-change line to be linked to
gt; the
gt; data point and the data label. This line is a vertical line from the data
gt; label at the top of the chart, down through the data point to the x-axis
gt; at
gt; the bottom. And this line needs to be locked (stick with) the data point
gt; and
gt; label as I change the source data for a new chart.
gt;
gt; Does this make sense? Can this be done?
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Put the comments into another column, then use one of these free Excel
gt;gt; add-ins to use these cells to label the points.
gt;gt;
gt;gt; Rob Bovey's Chart Labeler, appspro.com
gt;gt; John Walkenbach's Chart Tools, j-walk.com
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt;
gt;gt; quot;Tom Z.quot; lt;Tom gt; wrote in message
gt;gt; ...
gt;gt; gt; Using Excel, I have data numbers added in some cells. In those cells, I
gt;gt; gt; have
gt;gt; gt; inserted comments. When printing the chart, I want those comments
gt;gt; gt; printed
gt;gt; gt; next to the plotted data point.
gt;gt; gt;
gt;gt; gt; Can that be done? If so, how?
gt;gt;
gt;gt;
gt;gt;
Mr. Peltier:

Thank you again for your response. I hate to appear a dunce, but I am not
understanding. I seem to be able to make a vertical line by using a Y bar,
but to do that, I simply add another column of quot;phase changesquot;, and on a
particular month, in that column I had a number, high up on the Y scale. Then
that number is plotted separately on the chart. I then click on that and set
a Y bar at 100%, and the line goes down the graph all the way to the X axis.

However, when I then make another chart using a different set of source
data, that line seems to disappear, even if that particular month is part of
the graph.

Furthermore, I was not clear on what I meant by labeling that phase change.
I didn't mean data label for the data series. I meant a label describing what
the vertical line MEANS. FOr example, on one month, a particular child might
have started a new medication, so I would want that vertical line to be a
graphical statement of a change in the child's program, and then I want a
label, RIGHT ON THE CHART, next to the vertical line, that says quot;MED CHANGE.quot;
I have been trying to use text boxes, but they don't stay locked to the
particular month when I move to a new source data and the month shifts
position on the graph.

Does this make sense? Thanks again for your time and help.quot;Jon Peltierquot; wrote:

gt; Tom -
gt;
gt; Excel remembers that a label goes with point X of a series, so if your data
gt; range still includes the point, but dynamically you've moved it to point Y,
gt; the label stays at X. You need to use a dummy series then for your labels
gt; and phase-change line. I think I would add each phase change line as a
gt; separate one-point series so that the point (no marker) coincides with the
gt; point you want to highlight, and the point anchors the label. Use the label
gt; text as the series title, and it's easier to apply to the point than having
gt; to use one of these addins. Then use Y error bars that will reach down to
gt; the bottom and up to the top of the chart. It's related to this example:
gt;
gt; peltiertech.com/Excel/Charts/...ertErrBar.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;tom zanequot; lt;tom gt; wrote in message
gt; ...
gt; gt; Thank you very much, but those two programs are not doing what I need:
gt; gt;
gt; gt; I am entering number data per month - For example, January - 10; February
gt; gt; 24; March - 3; April - 15; and so on. I do this each month throughout the
gt; gt; year, and I have multiple years entered.
gt; gt;
gt; gt; I then construct line charts showing the data across a several-month
gt; gt; period.
gt; gt; It could be one calendar year, or it could be March 2004 through March
gt; gt; 2005.
gt; gt;
gt; gt; I need to occasionally label ONE month's data; then, whenever i change the
gt; gt; source data for the next chart, that label needs to STICK WITH the
gt; gt; assigned
gt; gt; data point and move with it when the new chart is constructed.
gt; gt;
gt; gt; Additionally, I need a (what I call) a phase-change line to be linked to
gt; gt; the
gt; gt; data point and the data label. This line is a vertical line from the data
gt; gt; label at the top of the chart, down through the data point to the x-axis
gt; gt; at
gt; gt; the bottom. And this line needs to be locked (stick with) the data point
gt; gt; and
gt; gt; label as I change the source data for a new chart.
gt; gt;
gt; gt; Does this make sense? Can this be done?
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt;gt; Put the comments into another column, then use one of these free Excel
gt; gt;gt; add-ins to use these cells to label the points.
gt; gt;gt;
gt; gt;gt; Rob Bovey's Chart Labeler, appspro.com
gt; gt;gt; John Walkenbach's Chart Tools, j-walk.com
gt; gt;gt;
gt; gt;gt; - Jon
gt; gt;gt; -------
gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; Peltier Technical Services
gt; gt;gt; Tutorials and Custom Solutions
gt; gt;gt; PeltierTech.com/
gt; gt;gt; _______
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Tom Z.quot; lt;Tom gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Using Excel, I have data numbers added in some cells. In those cells, I
gt; gt;gt; gt; have
gt; gt;gt; gt; inserted comments. When printing the chart, I want those comments
gt; gt;gt; gt; printed
gt; gt;gt; gt; next to the plotted data point.
gt; gt;gt; gt;
gt; gt;gt; gt; Can that be done? If so, how?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Mr. Peltier:

Two questions:

1. Using XY Chart labeler, if I make a label for a data point, and then
change the source data, will that label stay with that data point?

2. Is there some way that Excel can chart text onto a chart? If so, perhaps
that would be the easiest solution.
Thanks.

gt; Tom -
gt;
gt; Excel remembers that a label goes with point X of a series, so if your data
gt; range still includes the point, but dynamically you've moved it to point Y,
gt; the label stays at X. You need to use a dummy series then for your labels
gt; and phase-change line. I think I would add each phase change line as a
gt; separate one-point series so that the point (no marker) coincides with the
gt; point you want to highlight, and the point anchors the label. Use the label
gt; text as the series title, and it's easier to apply to the point than having
gt; to use one of these addins. Then use Y error bars that will reach down to
gt; the bottom and up to the top of the chart. It's related to this example:
gt;
gt; peltiertech.com/Excel/Charts/...ertErrBar.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;tom zanequot; lt;tom gt; wrote in message
gt; ...
gt; gt; Thank you very much, but those two programs are not doing what I need:
gt; gt;
gt; gt; I am entering number data per month - For example, January - 10; February
gt; gt; 24; March - 3; April - 15; and so on. I do this each month throughout the
gt; gt; year, and I have multiple years entered.
gt; gt;
gt; gt; I then construct line charts showing the data across a several-month
gt; gt; period.
gt; gt; It could be one calendar year, or it could be March 2004 through March
gt; gt; 2005.
gt; gt;
gt; gt; I need to occasionally label ONE month's data; then, whenever i change the
gt; gt; source data for the next chart, that label needs to STICK WITH the
gt; gt; assigned
gt; gt; data point and move with it when the new chart is constructed.
gt; gt;
gt; gt; Additionally, I need a (what I call) a phase-change line to be linked to
gt; gt; the
gt; gt; data point and the data label. This line is a vertical line from the data
gt; gt; label at the top of the chart, down through the data point to the x-axis
gt; gt; at
gt; gt; the bottom. And this line needs to be locked (stick with) the data point
gt; gt; and
gt; gt; label as I change the source data for a new chart.
gt; gt;
gt; gt; Does this make sense? Can this be done?
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt;gt; Put the comments into another column, then use one of these free Excel
gt; gt;gt; add-ins to use these cells to label the points.
gt; gt;gt;
gt; gt;gt; Rob Bovey's Chart Labeler, appspro.com
gt; gt;gt; John Walkenbach's Chart Tools, j-walk.com
gt; gt;gt;
gt; gt;gt; - Jon
gt; gt;gt; -------
gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; Peltier Technical Services
gt; gt;gt; Tutorials and Custom Solutions
gt; gt;gt; PeltierTech.com/
gt; gt;gt; _______
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Tom Z.quot; lt;Tom gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Using Excel, I have data numbers added in some cells. In those cells, I
gt; gt;gt; gt; have
gt; gt;gt; gt; inserted comments. When printing the chart, I want those comments
gt; gt;gt; gt; printed
gt; gt;gt; gt; next to the plotted data point.
gt; gt;gt; gt;
gt; gt;gt; gt; Can that be done? If so, how?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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.

quot;Jon Peltierquot; wrote:

gt; Tom -
gt;
gt; Excel remembers that a label goes with point X of a series, so if your data
gt; range still includes the point, but dynamically you've moved it to point Y,
gt; the label stays at X. You need to use a dummy series then for your labels
gt; and phase-change line. I think I would add each phase change line as a
gt; separate one-point series so that the point (no marker) coincides with the
gt; point you want to highlight, and the point anchors the label. Use the label
gt; text as the series title, and it's easier to apply to the point than having
gt; to use one of these addins. Then use Y error bars that will reach down to
gt; the bottom and up to the top of the chart. It's related to this example:
gt;
gt; peltiertech.com/Excel/Charts/...ertErrBar.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;tom zanequot; lt;tom gt; wrote in message
gt; ...
gt; gt; Thank you very much, but those two programs are not doing what I need:
gt; gt;
gt; gt; I am entering number data per month - For example, January - 10; February
gt; gt; 24; March - 3; April - 15; and so on. I do this each month throughout the
gt; gt; year, and I have multiple years entered.
gt; gt;
gt; gt; I then construct line charts showing the data across a several-month
gt; gt; period.
gt; gt; It could be one calendar year, or it could be March 2004 through March
gt; gt; 2005.
gt; gt;
gt; gt; I need to occasionally label ONE month's data; then, whenever i change the
gt; gt; source data for the next chart, that label needs to STICK WITH the
gt; gt; assigned
gt; gt; data point and move with it when the new chart is constructed.
gt; gt;
gt; gt; Additionally, I need a (what I call) a phase-change line to be linked to
gt; gt; the
gt; gt; data point and the data label. This line is a vertical line from the data
gt; gt; label at the top of the chart, down through the data point to the x-axis
gt; gt; at
gt; gt; the bottom. And this line needs to be locked (stick with) the data point
gt; gt; and
gt; gt; label as I change the source data for a new chart.
gt; gt;
gt; gt; Does this make sense? Can this be done?
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt;gt; Put the comments into another column, then use one of these free Excel
gt; gt;gt; add-ins to use these cells to label the points.
gt; gt;gt;
gt; gt;gt; Rob Bovey's Chart Labeler, appspro.com
gt; gt;gt; John Walkenbach's Chart Tools, j-walk.com
gt; gt;gt;
gt; gt;gt; - Jon
gt; gt;gt; -------
gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; Peltier Technical Services
gt; gt;gt; Tutorials and Custom Solutions
gt; gt;gt; PeltierTech.com/
gt; gt;gt; _______
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Tom Z.quot; lt;Tom gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Using Excel, I have data numbers added in some cells. In those cells, I
gt; gt;gt; gt; have
gt; gt;gt; gt; inserted comments. When printing the chart, I want those comments
gt; gt;gt; gt; printed
gt; gt;gt; gt; next to the plotted data point.
gt; gt;gt; gt;
gt; gt;gt; gt; Can that be done? If so, how?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______quot;tom zanequot; gt; wrote in message
...
gt; Mr. Peltier:
gt;
gt; Hi again. I answered my own question. When I use XY Chart Labeler, and
gt; then
gt; change the source data, the data label STAYS PUT and does not change
gt; position
gt; with the data point to which it was assigned.
gt;
gt; So, I still am trying to figure out how I can put a vertical line in at a
gt; particular month, label what happened that month, and have that line and
gt; label move with that month's data when I change the source data.
gt;
gt; I thank you for your help.
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Tom -
gt;gt;
gt;gt; Excel remembers that a label goes with point X of a series, so if your
gt;gt; data
gt;gt; range still includes the point, but dynamically you've moved it to point
gt;gt; Y,
gt;gt; the label stays at X. You need to use a dummy series then for your labels
gt;gt; and phase-change line. I think I would add each phase change line as a
gt;gt; separate one-point series so that the point (no marker) coincides with
gt;gt; the
gt;gt; point you want to highlight, and the point anchors the label. Use the
gt;gt; label
gt;gt; text as the series title, and it's easier to apply to the point than
gt;gt; having
gt;gt; to use one of these addins. Then use Y error bars that will reach down to
gt;gt; the bottom and up to the top of the chart. It's related to this example:
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/...ertErrBar.html
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;tom zanequot; lt;tom gt; wrote in message
gt;gt; ...
gt;gt; gt; Thank you very much, but those two programs are not doing what I need:
gt;gt; gt;
gt;gt; gt; I am entering number data per month - For example, January - 10;
gt;gt; gt; February
gt;gt; gt; 24; March - 3; April - 15; and so on. I do this each month throughout
gt;gt; gt; the
gt;gt; gt; year, and I have multiple years entered.
gt;gt; gt;
gt;gt; gt; I then construct line charts showing the data across a several-month
gt;gt; gt; period.
gt;gt; gt; It could be one calendar year, or it could be March 2004 through March
gt;gt; gt; 2005.
gt;gt; gt;
gt;gt; gt; I need to occasionally label ONE month's data; then, whenever i change
gt;gt; gt; the
gt;gt; gt; source data for the next chart, that label needs to STICK WITH the
gt;gt; gt; assigned
gt;gt; gt; data point and move with it when the new chart is constructed.
gt;gt; gt;
gt;gt; gt; Additionally, I need a (what I call) a phase-change line to be linked
gt;gt; gt; to
gt;gt; gt; the
gt;gt; gt; data point and the data label. This line is a vertical line from the
gt;gt; gt; data
gt;gt; gt; label at the top of the chart, down through the data point to the
gt;gt; gt; x-axis
gt;gt; gt; at
gt;gt; gt; the bottom. And this line needs to be locked (stick with) the data
gt;gt; gt; point
gt;gt; gt; and
gt;gt; gt; label as I change the source data for a new chart.
gt;gt; gt;
gt;gt; gt; Does this make sense? Can this be done?
gt;gt; gt;
gt;gt; gt; quot;Jon Peltierquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Put the comments into another column, then use one of these free Excel
gt;gt; gt;gt; add-ins to use these cells to label the points.
gt;gt; gt;gt;
gt;gt; gt;gt; Rob Bovey's Chart Labeler, appspro.com
gt;gt; gt;gt; John Walkenbach's Chart Tools, j-walk.com
gt;gt; gt;gt;
gt;gt; gt;gt; - Jon
gt;gt; gt;gt; -------
gt;gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; gt;gt; Peltier Technical Services
gt;gt; gt;gt; Tutorials and Custom Solutions
gt;gt; gt;gt; PeltierTech.com/
gt;gt; gt;gt; _______
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Tom Z.quot; lt;Tom gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Using Excel, I have data numbers added in some cells. In those
gt;gt; gt;gt; gt; cells, I
gt;gt; gt;gt; gt; have
gt;gt; gt;gt; gt; inserted comments. When printing the chart, I want those comments
gt;gt; gt;gt; gt; printed
gt;gt; gt;gt; gt; next to the plotted data point.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Can that be done? If so, how?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
1. Discussed in response to your other post.
2. Make a data series with x,y pairs where you want to center a label. Plot
the points in an XY series, use the chart labeler to apply the labels, using
the Center alignment option, then format the series without lines or
markers. It is an easy solution, once you get the hang of it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;tom zanequot; gt; wrote in message
...
gt; Mr. Peltier:
gt;
gt; Two questions:
gt;
gt; 1. Using XY Chart labeler, if I make a label for a data point, and then
gt; change the source data, will that label stay with that data point?
gt;
gt; 2. Is there some way that Excel can chart text onto a chart? If so,
gt; perhaps
gt; that would be the easiest solution.
gt; Thanks.
gt;
gt;gt; Tom -
gt;gt;
gt;gt; Excel remembers that a label goes with point X of a series, so if your
gt;gt; data
gt;gt; range still includes the point, but dynamically you've moved it to point
gt;gt; Y,
gt;gt; the label stays at X. You need to use a dummy series then for your labels
gt;gt; and phase-change line. I think I would add each phase change line as a
gt;gt; separate one-point series so that the point (no marker) coincides with
gt;gt; the
gt;gt; point you want to highlight, and the point anchors the label. Use the
gt;gt; label
gt;gt; text as the series title, and it's easier to apply to the point than
gt;gt; having
gt;gt; to use one of these addins. Then use Y error bars that will reach down to
gt;gt; the bottom and up to the top of the chart. It's related to this example:
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/...ertErrBar.html
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;tom zanequot; lt;tom gt; wrote in message
gt;gt; ...
gt;gt; gt; Thank you very much, but those two programs are not doing what I need:
gt;gt; gt;
gt;gt; gt; I am entering number data per month - For example, January - 10;
gt;gt; gt; February
gt;gt; gt; 24; March - 3; April - 15; and so on. I do this each month throughout
gt;gt; gt; the
gt;gt; gt; year, and I have multiple years entered.
gt;gt; gt;
gt;gt; gt; I then construct line charts showing the data across a several-month
gt;gt; gt; period.
gt;gt; gt; It could be one calendar year, or it could be March 2004 through March
gt;gt; gt; 2005.
gt;gt; gt;
gt;gt; gt; I need to occasionally label ONE month's data; then, whenever i change
gt;gt; gt; the
gt;gt; gt; source data for the next chart, that label needs to STICK WITH the
gt;gt; gt; assigned
gt;gt; gt; data point and move with it when the new chart is constructed.
gt;gt; gt;
gt;gt; gt; Additionally, I need a (what I call) a phase-change line to be linked
gt;gt; gt; to
gt;gt; gt; the
gt;gt; gt; data point and the data label. This line is a vertical line from the
gt;gt; gt; data
gt;gt; gt; label at the top of the chart, down through the data point to the
gt;gt; gt; x-axis
gt;gt; gt; at
gt;gt; gt; the bottom. And this line needs to be locked (stick with) the data
gt;gt; gt; point
gt;gt; gt; and
gt;gt; gt; label as I change the source data for a new chart.
gt;gt; gt;
gt;gt; gt; Does this make sense? Can this be done?
gt;gt; gt;
gt;gt; gt; quot;Jon Peltierquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Put the comments into another column, then use one of these free Excel
gt;gt; gt;gt; add-ins to use these cells to label the points.
gt;gt; gt;gt;
gt;gt; gt;gt; Rob Bovey's Chart Labeler, appspro.com
gt;gt; gt;gt; John Walkenbach's Chart Tools, j-walk.com
gt;gt; gt;gt;
gt;gt; gt;gt; - Jon
gt;gt; gt;gt; -------
gt;gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; gt;gt; Peltier Technical Services
gt;gt; gt;gt; Tutorials and Custom Solutions
gt;gt; gt;gt; PeltierTech.com/
gt;gt; gt;gt; _______
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Tom Z.quot; lt;Tom gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Using Excel, I have data numbers added in some cells. In those
gt;gt; gt;gt; gt; cells, I
gt;gt; gt;gt; gt; have
gt;gt; gt;gt; gt; inserted comments. When printing the chart, I want those comments
gt;gt; gt;gt; gt; printed
gt;gt; gt;gt; gt; next to the plotted data point.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Can that be done? If so, how?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Hi Tom -

See comments inline

gt; Thank you again for your response. I hate to appear a dunce, but I am not
gt; understanding. I seem to be able to make a vertical line by using a Y bar,
gt; but to do that, I simply add another column of quot;phase changesquot;, and on a
gt; particular month, in that column I had a number, high up on the Y scale.
gt; Then
gt; that number is plotted separately on the chart. I then click on that and
gt; set
gt; a Y bar at 100%, and the line goes down the graph all the way to the X
gt; axis.
gt;
gt; However, when I then make another chart using a different set of source
gt; data, that line seems to disappear, even if that particular month is part
gt; of
gt; the graph.

Did you include the phase change source data in this chart? You need to
include it and format the line the way you need it. Or make a copy of the
original chart, and use Chart menu gt; Source Data gt; Series tab, to select
different data for the main series.

gt; Furthermore, I was not clear on what I meant by labeling that phase
gt; change.
gt; I didn't mean data label for the data series. I meant a label describing
gt; what
gt; the vertical line MEANS. FOr example, on one month, a particular child
gt; might

That's what I thought you meant, but perhaps my response wasn't clear. I
made a suggestion to your other follow up.

gt; have started a new medication, so I would want that vertical line to be a
gt; graphical statement of a change in the child's program, and then I want a
gt; label, RIGHT ON THE CHART, next to the vertical line, that says quot;MED
gt; CHANGE.quot;
gt; I have been trying to use text boxes, but they don't stay locked to the
gt; particular month when I move to a new source data and the month shifts
gt; position on the graph.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______