LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default How to replace numeric values with letters in a diagram?

I would like to use values of "A, B, C, D.." (grades) instead of numeric
values in a graphic visualisation of a score in different moments in time
(semesters). Can anyone give me a hint or some instructions on how to do this?

ex: if I name the rows math, physics and chemestry, and the columns first,
second, third and fourth semestre, I can easily plot in numeric values like
1, 2, 3, 4.. etc. to get the diagrams to show the right score as a hight of
each column in the diagram. But I would like the diagram to show the results
for 1=f, 2=e, 3=d etc. and be able to plot a, b, c... etc. directly into the
cells. Is this possible? Or is it possible to rename the values of ther
columns in the diagram, so that at least it will apear as a, b, c..?

Thanks for your help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column grid is numeric I want letters - A B C D etc., Elaine New Users to Excel 4 September 9th 07 01:18 PM
letters drive a numeric result mblush Excel Worksheet Functions 3 February 23rd 07 07:05 PM
Return Numeric Labels that have different Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 8 December 3rd 06 02:06 AM
Sepearting Numeric Data from Letters jstock Excel Discussion (Misc queries) 1 April 25th 06 06:26 AM
Diagram row values louise Excel Worksheet Functions 6 December 14th 04 11:25 PM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"