+ Reply to Thread
Results 1 to 3 of 3

How can I display chart graph bars in an order different than data is sorted?

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    ohio
    MS-Off Ver
    Home and Business 2010
    Posts
    5

    How can I display chart graph bars in an order different than data is sorted?

    I am trying to compare the frequency of occurrence of multiple unique values within a data set and graph the results as a pareto.
    I have the formulas working to identify and count the occurrences, and the chart is designed and displaying the data, however I cannot get the graph to display in descending order.

    I am unable to sort the data because it is generated from a series of formulas, the returned values of which cannot be sorted. (its hard to describe, see the attached workbook)

    I would like to know how I can display the graph so that it shows the bars (primary axis) in descending order (highest value to left, lowest to right) since I cannot sort the data.
    i.e. For the attached workbook, I want the bars to display in descending number of occurrences: 81,15,5,5,3,3,2,2.

    I really need help with this, so any help would be greatly appreciated.
    Thank you!

    Workbook attached.
    Attached Files Attached Files
    Last edited by cbrf23; 02-21-2014 at 03:12 PM.

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

    Re: How can I display chart graph bars in an order different than data is sorted?

    The chart will not sort the data so you will need to use more formula to order the data points and labels. Then plot those.

    Alternatively you could create pivot table/charts in the 4 data columns.

    Or better yet condense your data and create a pivot table/chart that you can select which data set to show in ordered chart.

    See attached for pivot chart examples
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-05-2011
    Location
    ohio
    MS-Off Ver
    Home and Business 2010
    Posts
    5

    Re: How can I display chart graph bars in an order different than data is sorted?

    Andy, that looks to be exactly what I need.
    I will have to look into pivot tables and pivot charts, this is not something I'm very familiar with.

    Thank you!

+ 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. Display chart data in descending order
    By Aland2929 in forum Excel General
    Replies: 2
    Last Post: 11-21-2011, 06:36 AM
  2. Replies: 2
    Last Post: 10-17-2011, 04:45 AM
  3. Bars on Chart Display are Wrong
    By Mordred in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-11-2011, 10:37 AM
  4. Order of Bars in Cluster Chart
    By ykirksey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2007, 06:14 PM
  5. How can I display two seperate stacked bars in a graph
    By ndavies in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-15-2006, 07:10 PM

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