+ Reply to Thread
Results 1 to 3 of 3

How do I rank chart data so it appears in a specific order?

  1. #1
    kim
    Guest

    How do I rank chart data so it appears in a specific order?

    I want to organize the charted results in decending order of longest bar to
    shortest bar so a natural progression or trend can be seen easily. Help!!

  2. #2
    Mike Middleton
    Guest

    Re: How do I rank chart data so it appears in a specific order?

    kim -

    Usually a chart depends on data in a worksheet.
    So, sort the data.

    - Mike
    www.mikemiddleton.com

    "kim" <kim@discussions.microsoft.com> wrote in message
    news:D26975C9-8346-49CE-BA39-F2304DB8079A@microsoft.com...
    >I want to organize the charted results in decending order of longest bar to
    > shortest bar so a natural progression or trend can be seen easily. Help!!




  3. #3
    Tushar Mehta
    Guest

    Re: How do I rank chart data so it appears in a specific order?

    An alternative to Mike's suggestion is to do the sort through a named
    formula. Create a named formula named DataRng (Insert | Name >
    Define...) that refers to your data set. Then, add another named
    formula (SortedData2 below).

    DataRng =Sheet1!$D$5:$D$34
    SortedData2 =LARGE(DataRng,ROW(DataRng)-ROW(INDEX(DataRng,1))+1)

    Now, plot SortedData2. For more on named formulas and charts see they
    Dynamic Charts page of my web site. [I'm on a plane and cannot provide
    you the exact URL.]

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Multi-disciplinary business expertise
    + Technology skills
    = Optimal solution to your business problem
    Recipient Microsoft MVP award 2000-2005

    In article <D26975C9-8346-49CE-BA39-F2304DB8079A@microsoft.com>,
    kim@discussions.microsoft.com says...
    > I want to organize the charted results in decending order of longest bar to
    > shortest bar so a natural progression or trend can be seen easily. Help!!
    >


+ 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.6.0 RC 1