Excel charts should let me select a range for data labels.
 

I use Excel 97.
I want to graph the progression of my test GRADES. I can create a line chart
that graphs my three test scores on three different days, 81 in January, 85
in February, and 89 in March. However, I would like the data labels to
reflect my GRADE and not my SCORE. While I want the chart to graph my SCORES
of 81, 85, and 89 - I want the labels to reflect "B-", "B", and "B+" and not
the actual numerical SCORES.

So, I would like the option to select a different column for my DATA LABELS.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

xl2002
right clicksourceserieschange to suit
use f2 to edit freely

--
Don Guillett
SalesAid Software

"Relmbo" wrote in message
...
I use Excel 97.
I want to graph the progression of my test GRADES. I can create a line
chart
that graphs my three test scores on three different days, 81 in January,
85
in February, and 89 in March. However, I would like the data labels to
reflect my GRADE and not my SCORE. While I want the chart to graph my
SCORES
of 81, 85, and 89 - I want the labels to reflect "B-", "B", and "B+" and
not
the actual numerical SCORES.

So, I would like the option to select a different column for my DATA
LABELS.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...excel.charting

Yes, no currently available version of XL supports that capability.
However, it is possible. For automated solutions get XY Chart labeler
(www.appspro.com) or Chart Tools (www.j-walk.com). For a "roll your
own" approach see
Data Labels
http://www.tushar-mehta.com/excel/ne...els/index.html

--
Regards,

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

In article ,
says...
I use Excel 97.
I want to graph the progression of my test GRADES. I can create a line chart
that graphs my three test scores on three different days, 81 in January, 85
in February, and 89 in March. However, I would like the data labels to
reflect my GRADE and not my SCORE. While I want the chart to graph my SCORES
of 81, 85, and 89 - I want the labels to reflect "B-", "B", and "B+" and not
the actual numerical SCORES.

So, I would like the option to select a different column for my DATA LABELS.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

I misunderstood. datalabels....

--
Don Guillett
SalesAid Software

"Tushar Mehta" wrote in message
om...
Yes, no currently available version of XL supports that capability.
However, it is possible. For automated solutions get XY Chart labeler
(www.appspro.com) or Chart Tools (www.j-walk.com). For a "roll your
own" approach see
Data Labels
http://www.tushar-mehta.com/excel/ne...els/index.html

--
Regards,

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

In article ,
says...
I use Excel 97.
I want to graph the progression of my test GRADES. I can create a line
chart
that graphs my three test scores on three different days, 81 in January,
85
in February, and 89 in March. However, I would like the data labels to
reflect my GRADE and not my SCORE. While I want the chart to graph my
SCORES
of 81, 85, and 89 - I want the labels to reflect "B-", "B", and "B+" and
not
the actual numerical SCORES.

So, I would like the option to select a different column for my DATA
LABELS.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...excel.charting