Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default line chart using letters not numbers

I am trying to graph reading levels for a class, the levels are letters not
numbers. My data would include; student name, level, month, (example: Lily,
U, September). I understand I need to make a line chart but how do I change
the values to letters not numbers. Thank you
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: line chart using letters not numbers

Creating a Line Chart in Excel Using Letters Instead of Numbers

To start, you'll need to enter your data into Excel. You mentioned that you have three pieces of data for each student: their name, their reading level (which is a letter), and the month. So, you'll want to create three columns in Excel, one for each piece of data.

Once you have your data entered, you can create a line chart by following these steps:
  1. Select the three columns of data you just created.
  2. Click on the Insert tab in the Excel ribbon.
  3. Click on the Line chart type.
  4. Excel will automatically create a line chart for you, but the reading levels will be displayed as numbers on the vertical axis.
  5. To change the vertical axis to display letters instead of numbers, right-click on the vertical axis and select Format Axis from the dropdown menu.
  6. In the Format Axis pane that appears on the right side of the screen, under Axis Options, change the Minimum value to 0 and the Maximum value to the number of levels you have (for example, if you have levels A-Z, you would set the maximum value to 25).
  7. Under Axis Options, click on the dropdown menu next to Vertical axis crosses and select Axis value.
  8. In the Axis value box, enter 0.
  9. Under Number, select Custom and in the Type box, enter "@" (without the quotes).
  10. Click Close to close the Format Axis pane.

Your line chart should now display the reading levels as letters on the vertical axis. If you have any trouble with these steps, feel free to let me know and I'll do my best to help you out!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default line chart using letters not numbers

Assign a code, which may be like A=5, B=4, C=3, etc. Plot this numerical
data, then use an artificial axis to place the text labels along the axis at
positions corresponding to their numerical values:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Reeder88" wrote in message
...
I am trying to graph reading levels for a class, the levels are letters not
numbers. My data would include; student name, level, month, (example:
Lily,
U, September). I understand I need to make a line chart but how do I
change
the values to letters not numbers. Thank you



Reply
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
Line chart with negative numbers - X-axis problem Judi Excel Discussion (Misc queries) 1 March 28th 07 02:51 AM
Line chart with negative numbers - X-axis problem Judi Excel Discussion (Misc queries) 0 March 28th 07 12:55 AM
Excel pie chart title words break to next line between letters? sweetsweed Charts and Charting in Excel 0 October 9th 06 07:10 PM
create self-generating numbers with letters and numbers cxlough41 Excel Discussion (Misc queries) 11 January 4th 06 01:16 AM
how to insert numbers/letters in a chart vijay Charts and Charting in Excel 2 December 10th 04 09:45 PM


All times are GMT +1. The time now is 04:25 PM.

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

About Us

"It's about Microsoft Excel"