Chart Suggestions - Relationships (other than scatter)

[Yvonne Love]

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

 

[NARAYANK991]

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

 

[GraH - Guido]

Hi, take a look on the blog, I find this https://chandoo.org/wp/2010/04/19/chart-selection-process/ rather interesting.

 

[Yvonne Love]

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

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Yvonne Love]

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

 

[Chihiro]

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.

 

[Yvonne Love]

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