I have an XY graph with five lines. At the bottom, is the legend that shows
the values that pertain to each line, say 5%, 6%, 7%, 8%, and 9%. But it
doesn't show the name of what those values represent, such as "interest
rate". I am not sure how to get that name, which would be found in some
cell (so it can change), into the legend box. Can someone tell me how this
is done (without macros), please? If the name cannot come from a cell but
must be inserted manually into the legend, that is OK, too, though less
preferable.

Thanks!
Dean

Hi Dean,

Right click on the Chart. Select Chart Options. Select Titles.


Alan


"The only dumb question is a question left unasked."


"Dean" wrote in message
...
I have an XY graph with five lines. At the bottom, is the legend that
shows the values that pertain to each line, say 5%, 6%, 7%, 8%, and 9%.
But it doesn't show the name of what those values represent, such as
"interest rate". I am not sure how to get that name, which would be found
in some cell (so it can change), into the legend box. Can someone tell me
how this is done (without macros), please? If the name cannot come from a
cell but must be inserted manually into the legend, that is OK, too, though
less preferable.

Thanks!
Dean

Perhaps, I was not clear enough (or else I'm dumb). Actually, it is a line
graph, not XY, though I see no change if I change it to XY. I already have
names for the chart itself and x and y axis. What I don't have names for
are the legend labels for the values of the five lines on the chart. When I
go to where you're talking, the first 3 of 5 boxes are filled in and the
last two are hushed, and I'm not sure that those two hushed boxes would be
the right places anyway.

A workaround is to use a custom format on the 5 values, putting an "interest
rate" 0% type format. The chart then shows the word in front of the number.
But this seems to be something I shouldn't have to work around.

Thanks!
Dean

"Alan" wrote in message
...
Hi Dean,

Right click on the Chart. Select Chart Options. Select Titles.


Alan


"The only dumb question is a question left unasked."


"Dean" wrote in message
...
I have an XY graph with five lines. At the bottom, is the legend that
shows the values that pertain to each line, say 5%, 6%, 7%, 8%, and 9%.
But it doesn't show the name of what those values represent, such as
"interest rate". I am not sure how to get that name, which would be found
in some cell (so it can change), into the legend box. Can someone tell me
how this is done (without macros), please? If the name cannot come from a
cell but must be inserted manually into the legend, that is OK, too,
though less preferable.

Thanks!
Dean

The "Legend" always shows the Series name next to the key (an icon like
representation of the series format). You can change the series names in
various ways, try right-click chart and Source Data...

Regards,
Peter T

You can change the series name in the
"Dean" wrote in message
...
Perhaps, I was not clear enough (or else I'm dumb). Actually, it is a
line
graph, not XY, though I see no change if I change it to XY. I already
have
names for the chart itself and x and y axis. What I don't have names for
are the legend labels for the values of the five lines on the chart. When
I
go to where you're talking, the first 3 of 5 boxes are filled in and the
last two are hushed, and I'm not sure that those two hushed boxes would be
the right places anyway.

A workaround is to use a custom format on the 5 values, putting an
"interest
rate" 0% type format. The chart then shows the word in front of the
number.
But this seems to be something I shouldn't have to work around.

Thanks!
Dean

"Alan" wrote in message
...
Hi Dean,

Right click on the Chart. Select Chart Options. Select Titles.


Alan


"The only dumb question is a question left unasked."


"Dean" wrote in message
...
I have an XY graph with five lines. At the bottom, is the legend that
shows the values that pertain to each line, say 5%, 6%, 7%, 8%, and 9%.
But it doesn't show the name of what those values represent, such as
"interest rate". I am not sure how to get that name, which would be
found
in some cell (so it can change), into the legend box. Can someone tell
me
how this is done (without macros), please? If the name cannot come from
a
cell but must be inserted manually into the legend, that is OK, too,
though less preferable.

Thanks!
Dean

Boy, I'm really thick on this one! I have five series of data of Y versus
X - each is a line of a different color. The series names are 5%, 6%, 7%,
8%, and 9% right now, these names are coming from cells. I could change
them all to one cell that says "Interest Rate", but then the name in the
legend beside each color sample would all be the same.

"Peter T" <peter_t@discussions wrote in message
...
The "Legend" always shows the Series name next to the key (an icon like
representation of the series format). You can change the series names in
various ways, try right-click chart and Source Data...

Regards,
Peter T

You can change the series name in the
"Dean" wrote in message
...
Perhaps, I was not clear enough (or else I'm dumb). Actually, it is a
line
graph, not XY, though I see no change if I change it to XY. I already
have
names for the chart itself and x and y axis. What I don't have names for
are the legend labels for the values of the five lines on the chart.
When
I
go to where you're talking, the first 3 of 5 boxes are filled in and the
last two are hushed, and I'm not sure that those two hushed boxes would
be
the right places anyway.

A workaround is to use a custom format on the 5 values, putting an
"interest
rate" 0% type format. The chart then shows the word in front of the
number.
But this seems to be something I shouldn't have to work around.

Thanks!
Dean

"Alan" wrote in message
...
Hi Dean,

Right click on the Chart. Select Chart Options. Select Titles.


Alan


"The only dumb question is a question left unasked."


"Dean" wrote in message
...
I have an XY graph with five lines. At the bottom, is the legend that
shows the values that pertain to each line, say 5%, 6%, 7%, 8%, and 9%.
But it doesn't show the name of what those values represent, such as
"interest rate". I am not sure how to get that name, which would be
found
in some cell (so it can change), into the legend box. Can someone tell
me
how this is done (without macros), please? If the name cannot come
from
a
cell but must be inserted manually into the legend, that is OK, too,
though less preferable.

Thanks!
Dean

shouldn't the cell that holds 5% hold 5% Interest Rate
instead. Or it you want it changeable, then in the cell the contains 5%,
change it to have a formula like

="5% "&A9

where A9 will hold the changeable value interest rate.

--
Regards,
Tom Ogilvy



"Dean" wrote in message
...
Boy, I'm really thick on this one! I have five series of data of Y versus
X - each is a line of a different color. The series names are 5%, 6%, 7%,
8%, and 9% right now, these names are coming from cells. I could change
them all to one cell that says "Interest Rate", but then the name in the
legend beside each color sample would all be the same.

"Peter T" <peter_t@discussions wrote in message
...
The "Legend" always shows the Series name next to the key (an icon like
representation of the series format). You can change the series names in
various ways, try right-click chart and Source Data...

Regards,
Peter T

You can change the series name in the
"Dean" wrote in message
...
Perhaps, I was not clear enough (or else I'm dumb). Actually, it is a
line
graph, not XY, though I see no change if I change it to XY. I already
have
names for the chart itself and x and y axis. What I don't have names
for
are the legend labels for the values of the five lines on the chart.
When
I
go to where you're talking, the first 3 of 5 boxes are filled in and the
last two are hushed, and I'm not sure that those two hushed boxes would
be
the right places anyway.

A workaround is to use a custom format on the 5 values, putting an
"interest
rate" 0% type format. The chart then shows the word in front of the
number.
But this seems to be something I shouldn't have to work around.

Thanks!
Dean

"Alan" wrote in message
...
Hi Dean,

Right click on the Chart. Select Chart Options. Select Titles.


Alan


"The only dumb question is a question left unasked."


"Dean" wrote in message
...
I have an XY graph with five lines. At the bottom, is the legend that
shows the values that pertain to each line, say 5%, 6%, 7%, 8%, and
9%.
But it doesn't show the name of what those values represent, such as
"interest rate". I am not sure how to get that name, which would be
found
in some cell (so it can change), into the legend box. Can someone
tell
me
how this is done (without macros), please? If the name cannot come
from
a
cell but must be inserted manually into the legend, that is OK, too,
though less preferable.

Thanks!
Dean