Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Non-numeric values in Charts

  1. #1
    Join Date
    9th February 2005
    Posts
    13

    Non-numeric values in Charts

    Hi,

    i'm trying to build a chart using two data ranges. The y-axis is numeric value, but the x-axis is non-numeric (corporate credit rating, like AAA, AA+, AA- and so on) in decending order, with AAA the best and AA+, AA, AA- and so on. Is it possible to build a chart with non-numeric values?

    Surely, i could replace this characters with numbers, but then the chart would display numeric characters and is not easy to read.

    Do you have any idea how to solve this problem?

    cheers,
    korsar

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    6th September 2004
    Posts
    438

    Re: Non-numeric values in Charts

    You can put text values on the x-axis with no problems, have you tried it yet?

    TJ
    Oh dear I need a beer
    Online Motorsport Game

  3. #3
    Join Date
    9th February 2005
    Posts
    13

    Re: Non-numeric values in Charts

    Quote Originally Posted by tinyjack
    You can put text values on the x-axis with no problems, have you tried it yet?

    TJ

    Yes... i did. Here is the simplified excel sheet and a corresponding chart with NUMERIC x-axis values. But instead i would like to display this AA's and BB's...
    i don't know how to do it?
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    6th September 2004
    Posts
    438

    Re: Non-numeric values in Charts

    BBB appears twice in your example data, how would this be handled?

    TJ
    Oh dear I need a beer
    Online Motorsport Game

  5. #5
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Non-numeric values in Charts

    Try changing the chart type to Line and then couple click the line series and set the line border to None.

    And as TJ points out your rating labels appear incorrect.

    Cheers
    Andy


  6. #6
    Join Date
    9th February 2005
    Posts
    13

    Re: Non-numeric values in Charts

    Quote Originally Posted by Andy Pope
    Try changing the chart type to Line and then couple click the line series and set the line border to None.

    And as TJ points out your rating labels appear incorrect.
    ... now it displays the characters... but, the order, in which they appear is not correct! ... AAA is the most left, followed by AA+ and AA and s.o.

    ... i need a Scatter-Plot... the purpose is to compare the relative attractiveness of companies with same rating... and there can be actually more than 2 companies with BBB rating (to TJ)... the chart has to show Ratings on the x-axis (or y-axis if it will help the problem) and the spreads (it is a kind of risk measure) on the y-axis. Then one could easily compare the companies with the same rating, but different risk premium(spread).

    i hope, i could explain you the problem...
    thanx,
    korsar

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Non-numeric values in Charts

    You will have to make a combination chart.

    Plot the points on the primary axis and xy scatter. This will allow for the points with the same rating to appear in the same x axis value.

    You will need another data series to provide the ratings category labels.
    The data labels can either be modified by hand or linked to cells.

    I have also included a lookup table so you can add additional ratings in the correct order.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Cheers
    Andy


  8. #8
    Join Date
    9th February 2005
    Posts
    13

    Re: Non-numeric values in Charts

    Quote Originally Posted by Andy Pope
    You will have to make a combination chart.

    Plot the points on the primary axis and xy scatter. This will allow for the points with the same rating to appear in the same x axis value.

    You will need another data series to provide the ratings category labels.
    The data labels can either be modified by hand or linked to cells.

    I have also included a lookup table so you can add additional ratings in the correct order.
    Great solution! ... especially the trick with dummy zero's

    thanx a lot!
    korsar

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    29th August 2004
    Posts
    28

    Re: Non-numeric values in Charts

    You can make the label points invisible if you click on one of them. Then select Format Data Series and set the marker to none.

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    28th September 2010
    Posts
    1

    Re: Non-numeric values in Charts

    This is a cool solution, and I was able to use it as the basis for the bubble chart I am making, which turned out awesome. The thing is, I am still somewhat of a novice with the charts, and so while I was able to modify your charts for my needs, I still don't fully understand how this chart works.

    My main question I guess is how did you get the X axis labels to get there? Are they coming from row J?

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Copy Values Outside Of Numeric Range
    By channel7 in forum EXCEL HELP
    Replies: 12
    Last Post: September 15th, 2007, 01:10
  2. Macro Does Not Run With Numeric Values
    By gerardf in forum EXCEL HELP
    Replies: 2
    Last Post: June 9th, 2007, 12:27
  3. Determine Values In A Range Are Numeric
    By mrfitness in forum EXCEL HELP
    Replies: 7
    Last Post: April 13th, 2007, 04:27
  4. VBA to ID numeric values in formula
    By ExcelDigger in forum EXCEL HELP
    Replies: 4
    Last Post: January 6th, 2005, 08:14
  5. Charts: Replace Values in Charts
    By mimi in forum EXCEL HELP
    Replies: 8
    Last Post: August 17th, 2004, 18:42

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno