1

Basically, I need to show the total amt of sales made each week. For this case, let's put the figure at 200.

Now, I need to further breakdown this figure and segment them according to salesperson. e.g. Sally made 20 sales, John made 100 sales and Tom made 80 sales (total 200).

Is a pie-chart the best way to show this type of data?

Problem with the piechart is that if the sales people gets more than 8 or more, it starts getting messy and hard to read.

Any suggestions?

closed as too broad by msp, Mayo, Evil Closet Monkey, Devin, Graham Herrli May 2 '16 at 21:39

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Can you clarify your question a little. It's not clear in what context you need to represent your sales - e.g. are we talking an Excel spreadsheet? Will it be primarily viewed on screen, or as a printout? Any other info we should know? – Monomeeth May 2 '16 at 6:32
  • The information is meant to be displayed on a website, as part of the Admin control panel UI. It's for the Administrator to read and view the stats. – Illo Yonex Illo May 2 '16 at 10:49
1

Pie charts are not good when you have to compare. Also, they have a limit of how many values to represent.

I would recommend a horizontal bar chart. Comparisons are much more easy and you can have many values. Also, the names of the employees are much more easy to read.

Keep the bar chart simple : Do not add grid-lines. X-axis values are not needed. Place the value of each bar on top. Place the total sales at the top of the chart.

enter image description here

2

I think that weekly total sales also be different from each other. In order to show overall performance, two different interconnected bar-chart can be a good solution for your problem.

enter image description here

  • Hi, tks a lot. Could you explain how to use and read this kind of inter-connected bar chart? Tks! :-) – Illo Yonex Illo May 2 '16 at 10:48
  • In my simple example, the first one is based on the weeks, total sales and the fragmentation by workers. In the second chart, the pieces in the first chart create another chart based on worker performance, color coding is used for that. Manager can say , hey this worker two shows good performance in long time while, orange becomes less by time and blue worker, fluctuates the most. From simple bar charts to complex bar charts when it is needed is better way from my experiences. – Abektes May 2 '16 at 10:54
  • Wow, this is darn awesome! I finally understand now! Ah, the genius of this thinking! Tks! :-) – Illo Yonex Illo May 2 '16 at 16:10

Not the answer you're looking for? Browse other questions tagged or ask your own question.