| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y axis change form numbers to text
I am trying to plot my students performance in each of their assignments by
producing a line graph to show whether they have moved up grades but cannot chnage the numbers on the y axis to grade letters is this possible? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Y axis change form numbers to text
The y-values must be numbers - that it how Excel knows how high to place
them You could use a conversion table (90 and above = A, 80 and above = B, etc Then use one of the chart labeler addins (I recommend Bovey's) Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Tushar's Hover Chart Label utility: http://tushar-mehta.com/excel/softwa...bel/index.html best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "carol" wrote in message ... I am trying to plot my students performance in each of their assignments by producing a line graph to show whether they have moved up grades but cannot chnage the numbers on the y axis to grade letters is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the y-axis on an Excel chart from numbers to words | Charts and Charting in Excel | |||
| User form - Testing for numbers or text | Excel Discussion (Misc queries) | |||
| how do I change the text size of a form check box | New Users to Excel | |||
| X Axis:Change Numbers on Chart ? Please Help! | Charts and Charting in Excel | |||
| Concantenate Text with numbers with fixed form | Excel Worksheet Functions | |||
Linear Mode
