If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I import Excel charts into ACCESS for reporting? | Marjie | Setting Up & Running Reports | 0 | January 19th, 2005 06:31 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Update Presentation with Excel charts and tables | Holly | Powerpoint | 2 | August 11th, 2004 06:03 PM |
Help w/ User-Defined Function | Tom | Worksheet Functions | 15 | April 7th, 2004 01:04 PM |