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

[Guest]

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/com...1f0eb71e1e&dg=microsoft.public.excel.charting

 

[Don Guillett]

xl2002
right click>source>series>change to suit
use f2 to edit freely

--
Don Guillett
SalesAid Software
(e-mail address removed)

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/com...1f0eb71e1e&dg=microsoft.public.excel.charting

 

[Tushar Mehta]

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/newsgroups/data_labels/index.html

--
Regards,

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

 

[Don Guillett]

I misunderstood. datalabels....