Greetings,
I have a worksheet with several thousand rows of data detainling real estate companies that listed or sold properties within a given time period.
I have used a pivot table to summarize this data so I could get a count of just how many properties each company listed or sold and the percentage of the whole for each.
The results are that one company stands clearly above the rest with 13% of the total sales or listings; another 15 or so fall into the 1% to 10% range and then there are hundreds in the less than one percent range.
I have been asked to create a line chart that will clearly illustrate that a few companies are responsible for most of the listings and sales.
Easy enough except that the HUNDREDS of >1% companies are just too much to handle - I wind up with a chart that can not be read.
So I tried grouping the >1% folks, but then that one group winds up with 48% and makes the top guys look like they are doing nothing at all. Not what is being requested.
I can get something more reasonable from a pie chart - It just does not have the impact.
Is there a way to do this in a line or bar chart that I simply am not seeing. Or is the pie going to have to be the answer?
Thanks for your thoughts.
I have a worksheet with several thousand rows of data detainling real estate companies that listed or sold properties within a given time period.
I have used a pivot table to summarize this data so I could get a count of just how many properties each company listed or sold and the percentage of the whole for each.
The results are that one company stands clearly above the rest with 13% of the total sales or listings; another 15 or so fall into the 1% to 10% range and then there are hundreds in the less than one percent range.
I have been asked to create a line chart that will clearly illustrate that a few companies are responsible for most of the listings and sales.
Easy enough except that the HUNDREDS of >1% companies are just too much to handle - I wind up with a chart that can not be read.
So I tried grouping the >1% folks, but then that one group winds up with 48% and makes the top guys look like they are doing nothing at all. Not what is being requested.
I can get something more reasonable from a pie chart - It just does not have the impact.
Is there a way to do this in a line or bar chart that I simply am not seeing. Or is the pie going to have to be the answer?
Thanks for your thoughts.