Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 26
Default Using Text in the y-axis of a line graph

Hello -

I have tried to find a solution to this (without using an add-in), but have
been unable.

Suppose we have values like this:
Time Rating Symbol
T1 Aaa
T2 Aa2
T3 Aa3
T4 Ba1
T5 Ba1
T6 Ba1
T7 B2
T8 Caa2
T9 Caa3
T10 Caa3
T11 C
T12 C

The problem is that Excel does not seem to understand how to rank the
ratings.

One nice way of doing this wopuld be to replace the ratings with numerical
values and then in the chart somehow replace the numerical values with the
corresponding ratings text.

This sems likea pretty difficult problem. If anyone has any insights i
would greatly appreciate it.

Best Regards,

Chris )


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Using Text in the y-axis of a line graph

Chris -

Excel does not know how to evaluate your alphanumeric codes. Because they
are not numeric, Excel just assumes they have a value of zero.

You are on the right track with an approach that replaces the codes with
numerical values. To get codes back onto the axis, you need to hide the
regular axis labels, then plot a helper XY series along the axis, with data
points where you want labels. Each data point has a data label, which serves
as a replacement axis label. The approach is described in several articles
listed he

http://peltiertech.com/Excel/Charts/...tml#AxisScales

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"ct60" wrote in message
...
Hello -

I have tried to find a solution to this (without using an add-in), but
have
been unable.

Suppose we have values like this:
Time Rating Symbol
T1 Aaa
T2 Aa2
T3 Aa3
T4 Ba1
T5 Ba1
T6 Ba1
T7 B2
T8 Caa2
T9 Caa3
T10 Caa3
T11 C
T12 C

The problem is that Excel does not seem to understand how to rank the
ratings.

One nice way of doing this wopuld be to replace the ratings with numerical
values and then in the chart somehow replace the numerical values with the
corresponding ratings text.

This sems likea pretty difficult problem. If anyone has any insights i
would greatly appreciate it.

Best Regards,

Chris )




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
X axis values on a line graph Marlene Charts and Charting in Excel 1 April 23rd 08 10:00 PM
Line - Bar Graph, 2 axis TSNS Charts and Charting in Excel 1 February 27th 08 05:08 AM
Line graph X-axis Gary T Charts and Charting in Excel 1 November 2nd 06 08:08 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 09:45 PM
Second x-axis for line graph Sabine Charts and Charting in Excel 1 August 18th 05 01:18 AM


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

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

About Us

"It's about Microsoft Excel"