1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart Suggestions - Relationships (other than scatter)

Discussion in 'Discuss Data Visualizations and Charting' started by Yvonne Love, Mar 21, 2018.

  1. Yvonne Love

    Yvonne Love Member

    Messages:
    65
    I'm looking for some chart suggestions, and I thought I would ask the experts. I work in a law firm, and what I'm trying to plot easily is the relationship of number of matters billed to total fees billed for our top 50 clients year to year (i.e., easily see which clients had only a few very expensive matters as opposed to clients that we handled a lot of matters for). It is not at all uncommon to have a few clients each year that ended up having only a few matters that had enough fees to make that client in the top 50 that year.

    I have been playing around with scatter plots, and I think they can be useful for sure, but I wanted to get thoughts on other types of graphs/charts that may be useful.

    I have attached a sample of the data along with the scatter plots I created.

    Thank you!
    YL

    Attached Files:

  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,619
    Hi ,

    What about a simple bar chart ?

    Show only the top 10.

    Provision can be made for selecting either the top 10 or the bottom 10.

    Sorting can also be provided for , so that the chart is sorted on the Fees or on the number of matters.

    Narayan

    Attached Files:

    Dillina likes this.
  3. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    777
    Dillina likes this.
  4. Yvonne Love

    Yvonne Love Member

    Messages:
    65
    Thanks Narayan. In the graph you made, the primary axis and values (fees) are in reverse order, but the values for the secondary axis (matters) are not. When I add the secondary vertical axis, the values do reverse order, but they also move to the right. Is there a way to have both sets of values match with the categories in reverse order where they still line up like the one you provided? (not sure how 3 files uploaded - they are all the same)

    Thanks!
    Y

    [Edit by Hui] - Deleted duplicate files

    Attached Files:

    Last edited by a moderator: Mar 21, 2018
  5. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,619
    Hi ,

    See the attached file.

    Narayan

    Attached Files:

  6. Yvonne Love

    Yvonne Love Member

    Messages:
    65
    Thank you! I'm not seeing how you were able to reverse those values. What options did you choose to do that?
  7. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,929
    From first sample. Select green series, and add Secondary Vertical.

    Then select the secondary vertical and revers order.

    Then select the secondary horizontal and make it cross at axis value Automatic.

    Re-select the secondary vertical and set it to cross at maximum category.

    Remove secondary vertical.
    Dillina and NARAYANK991 like this.
  8. Yvonne Love

    Yvonne Love Member

    Messages:
    65
    Thank you!! I like this view a lot but I have always had issues with the secondary axis!

Share This Page