+ Reply to Thread
Results 1 to 11 of 11

How can i change axis to show words instead of numbers as values

Hybrid View

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2013
    Posts
    4

    Angry How can i change axis to show words instead of numbers as values

    Hi folks

    I would like to know if it is possible to make a graph exactly like this in excel??
    help.png

    please help asap
    Last edited by AnniC; 03-06-2014 at 10:18 AM. Reason: update title

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,053

    Re: Am I being thick ??

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Never use Merged Cells in Excel

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,690

    Re: Graphs help

    This is about the best I can do to get it really close.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,690

    Re: Graphs help

    This one is closer...

  5. #5
    Registered User
    Join Date
    03-06-2014
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Graphs help

    To Forum moderators

    I apologise for my lack of clarity as to the title of my post.

    As i am not an expert in the field of excel i was unsure as to what to call the post.

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How can i change axis to show words instead of numbers as values

    Title is ok now!

    Sambo Kid

    Can you pls upload the sample sheet again?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  7. #7
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,690

    Re: How can i change axis to show words instead of numbers as values

    Cool, thanks Fotis, and BTW i did start a post on improvements/suggestions.

    AnniC, based on your new title I'm not sure if this gets you close enough but see what you think.
    Attached Files Attached Files
    Last edited by Sam Capricci; 03-06-2014 at 09:32 AM.

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

    Re: How can i change axis to show words instead of numbers as values

    Your image appears to show a chart that really distorts the data.
    The spacing for values between 0 and 50 consumes the same space as that showing 90 to 100. Surely they should be proportional?
    Cheers
    Andy
    www.andypope.info

  9. #9
    Registered User
    Join Date
    03-06-2014
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: How can i change axis to show words instead of numbers as values

    Basically all i am looking for is a graph similar to the one in the OP and also that Sambokid posted.

    the data i have is just a volume/intensity relationship for in exercise.

  10. #10
    Registered User
    Join Date
    03-06-2014
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: How can i change axis to show words instead of numbers as values

    Sambo kid how would i go about compiling the graph you sent me with a combi chart

  11. #11
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,690

    Re: How can i change axis to show words instead of numbers as values

    What I did just involved a lot of formatting, I deleted the x and y axis and substituted yours as columns A and B. Then changed the bar colors and the background colors to roughly match yours.
    Beyond that I can't answer more for now because I have a 2 hour meeting I'm going into shortly. If you have any more questions I can revisit when I get out of the meeting.

+ 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. Thick Top Border
    By scotfitz in forum Excel General
    Replies: 2
    Last Post: 05-11-2009, 10:42 AM
  2. How to keep Thick border when filtering
    By Zyphon in forum Excel General
    Replies: 1
    Last Post: 01-03-2008, 06:09 AM
  3. Thick Borders
    By OfficeBitty in forum Excel General
    Replies: 10
    Last Post: 11-28-2006, 11:16 AM
  4. Am I being thick?
    By Spellbound in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 03-22-2006, 09:34 PM
  5. Simple one, its just that I'm thick!
    By Moxy1980 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-21-2005, 04:55 AM

Tags for this Thread

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