Uncluttered graph suggestion?

DJFANDANGO

Board Regular
Joined
Mar 31, 2016
Messages
111
Office Version
  1. 365
Platform
  1. Windows
Good morning all,

Another question to my esteemed excelers!

I have 30 teams that perform 8 activities each (lots)... which graph/suggestion should I use to show these numbers without looking really cluttered?
See below what I have...
1600750577323.png


Just for reference I only have about a 1/3 of an A4 sheet to display this on... :-/

Many thanks in advance.

Book1
ABCDEFGHI
1TeamItem 1Item 2Item 3Item 4Item 5Item 6Item 7Item 8
21104492811285571593950841193
32341463112931023126675940
436099307312783104315581528
5466169199912191219170131523
651649536981542448814531024
766490013321253257549338667
8713288221438116314613451501333
983544391484973582111514341439
10916811998068899411456101517
1110378117090713118841427672935
1211480132537914371483922939
13121065413621599501585181316
141374438412672279454913671292
1514142397063515421258937
1615792158511761403135414221342833
17164811173210918112013151022591
181779512056648863610521539580
19181485268123015682166807041468
20191177129187714751581924997489
21202881321473888691907130521
222159371072578411704921095112
23221146771276457967497171854
2423301570122678015014386501362
25246626623699517111408567117
262513636883591247148711107051418
27267619823914481841317321172
2827982491409101653610101115940
292867514399379448821055640906
3029413854263305257431473283
31301437165131561910491229511014
Sheet1
 
Last edited:

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
That's a lot of information to convey. I would probably opt for something like a stacked column chart, assuming your primary focus is on illustrating the performance variations among teams, and secondarily to show the relative distribution among activity items. If your interest is on showing how some activity items are in higher demand, then this might not be the preferred option.
1600809790258.png
 
Upvote 0
I don't know how you want to show the information, or what's important in it. A 3D chart is going to be next to useless. Not sure a stacked column will do it.

My first inclination was to draw a line chart:

UnclutteredLineChart1.png


But no, that's still pretty cluttered. So using formulas I generated a new data range next to the first, where each column had another 2000 added to it. So the first column was just the values, the second column was the values + 2000, the third column the values + 4000, etc. This gave me some separation between the different series:

UnclutteredLineChart2.png


With a little formatting, this is pretty good. It seems your values are pretty random, but if there were any patterns in the data, they would be easier to see in this view:

UnclutteredLineChart3.png
 
Upvote 0
I don't know how you want to show the information, or what's important in it. A 3D chart is going to be next to useless. Not sure a stacked column will do it.

My first inclination was to draw a line chart:

View attachment 22902

But no, that's still pretty cluttered. So using formulas I generated a new data range next to the first, where each column had another 2000 added to it. So the first column was just the values, the second column was the values + 2000, the third column the values + 4000, etc. This gave me some separation between the different series:

View attachment 22903

With a little formatting, this is pretty good. It seems your values are pretty random, but if there were any patterns in the data, they would be easier to see in this view:

View attachment 22904
John,

These are all fab ideas, I particularly like the last 'Staggered Chart'... I'd potentially get away with adding data labels on them too... Brilliant, it's just what the doctor ordred!

Thank you!
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top