+ Reply to Thread
Results 1 to 8 of 8

2 axis of text?

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    CAnada
    MS-Off Ver
    2016
    Posts
    5

    2 axis of text?

    Hi all,
    This is what I have :

    Capture.PNG

    What i need :

    I need for each question to be in order (horizontaly) : AD is first, CG and then IF
    I need for each result to have a value : EVC is greater than CM therefor it will be higher than CM.
    How do I get a graph like the one in red?
    It seems I can't get the graph I want since there are no values, only text,

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: 2 axis of text?

    Why do you need a graph since this is clearly just an illustration?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    07-29-2016
    Location
    CAnada
    MS-Off Ver
    2016
    Posts
    5

    Re: 2 axis of text?

    Quote Originally Posted by mikeTRON View Post
    Why do you need a graph since this is clearly just an illustration?
    Are you kidding me?
    Well for your information I have a big chunk of data that I need to display as a graph so I can analyse it.

    Next time you don't know how to do something and have nothing to say, just dont post/comment.
    Last edited by Kevin12345; 07-29-2016 at 09:18 PM.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: 2 axis of text?

    I am asking you seriously WHY you want to make a graph if an illustration would do.

  5. #5
    Registered User
    Join Date
    07-29-2016
    Location
    CAnada
    MS-Off Ver
    2016
    Posts
    5

    Re: 2 axis of text?

    I am so sorry, I was thinking you were trolling me.

    I don't need a graph. I need something like the thing in drew in red... An illustration is fine I guess?

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: 2 axis of text?

    Quote Originally Posted by Kevin12345 View Post
    I am so sorry, I was thinking you were trolling me.
    I don't need a graph. I need something like the thing in drew in red... An illustration is fine I guess?
    Haha, no I prefer to take problems and re-frame them into as simple of a solution as possible.
    If this is static and will remain static, why not just draw it once with drawings and be done with it instead of trying to back into a clever solution that might not be worth the trouble?

  7. #7
    Registered User
    Join Date
    07-29-2016
    Location
    CAnada
    MS-Off Ver
    2016
    Posts
    5
    Quote Originally Posted by mikeTRON View Post
    Haha, no I prefer to take problems and re-frame them into as simple of a solution as possible.
    If this is static and will remain static, why not just draw it once with drawings and be done with it instead of trying to back into a clever solution that might not be worth the trouble?
    I will be adding lines (data to it). How would you draw it?

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: 2 axis of text?

    If you want to use a chart then you will need to generate numeric values as charts do not plot text.

    Create a lookup table of values and plot the result.

    In order to get the axis labelled correctly create 2 extra series and plot those along the x and y axis lines.
    Link data labels to cells in order to get text labelling.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-20-2015, 12:50 PM
  2. [SOLVED] How do I align text left the horizontal axis labels and wrap text them?
    By rs1aj in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-11-2015, 03:52 AM
  3. [SOLVED] How Do I Hide Zero Value Axis Titles where the axis is a text value and not numerical
    By krish2503 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2014, 04:01 PM
  4. [SOLVED] Two Y Axis's One X, Chart Data not in sync with X axis between Y axis's
    By MJSlattery in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-08-2013, 12:08 AM
  5. Charts: Format Axis to Text Axis in VBA?
    By RPhilbin83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2011, 05:49 AM
  6. Replies: 8
    Last Post: 02-12-2009, 10:12 AM
  7. [SOLVED] How to insert X axis scale values next to axis and X axis grid lin
    By vp23larry in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2005, 11:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1