+ Reply to Thread
Results 1 to 2 of 2

Thread: Bar chart upside down

  1. #1
    Registered User
    Join Date
    08-30-2011
    Location
    Arvada, Colorado
    MS-Off Ver
    Excel 2003
    Posts
    1

    Angry Bar chart upside down

    Greetings!

    I have a bar chart keyed to a list of some 30 names. The list shows how many times a particular customer has contacted my company using a standard COUNTIF formula, and that information is then set into a bar chart.

    The problem is that the bar chart is upside-down to the list sort. The list names go in ascending order from A - Z.

    The bar chart (over which I have no direct sort control) presents itself in descending order from Z - A.

    I would very much like the bar chart presented A - Z like the list. Any clues?

    Thanks very much,
    Brian

  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: Bar chart upside down

    Select the vertical axis and format, on the scale tab set both,

    Categories in reverse order
    Value (Y) axis crosses at maximum
    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