+ Reply to Thread
Results 1 to 2 of 2

Thread: Changing axis location

  1. #1
    Registered User
    Join Date
    07-26-2011
    Location
    melbourne
    MS-Off Ver
    Excel 2010
    Posts
    33

    Changing axis location

    I am very new to excel charts and apologise if this is a silly question.

    My chart has the following fields
    strongly agree
    agree
    neither agree or disagree
    disagree
    strongly disagree

    The fileds are represented based on the number of responses

    The X and Y axis currently intersect where there is 0 i.e. no responses.

    Is it possible to make the axis intersect below the neither agree or disagree field? This would make all the other fields (disagree, strongly disagree, dont know) fall below the axis.

    I have uploaded my chart for reference
    Attached Files Attached Files
    Last edited by ashmott; 10-02-2011 at 06:55 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    11,349

    Re: Changing axis location

    You would need to use negative values for those scores.

    You will also need to reverse the series order for those 3 series otherwise DK will appear before S.Disagree in the stack.
    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)

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.2.0