Finding a way to create a non-bland table in Excel

[JaiWoods]

Hello,

I've been stumped for the last few days trying to find a more creative way to display some data I have in a table. I looked at scatter charts and it wasn't a clean view of the data and bubble charts didn't work. I noticed some tables with bubbles over the values but wasn't really clear on how it was done.

I have been fishing around the blog but haven't found anything I could use.
I would appreciate any ideas or help.

Note: Here is an example of my data set. I have a column for location and then 5 columns with counts. The values in columns B-F will change weekly.

Category TOTAL VISITS TOTAL PURCHASES TOTAL COMPLETE SURVEYS TOTAL APPS TOTAL INTERVIEWS
A 5 6 34 8 11
B 10 4 53 43 98
C 3 44 23 67 78
D 5 6 1 12 66
E 8 78 2 11 12
F 9 9 55 3 35
G 2 23 7 4 34
H 0 4 98 1 53
I 3 55 78 0 23
J 4 7 66 11 1
K 65 98 12 98 2
L 12 3 0 78 3
M 88 4 0 66 53
N 54 1 0 12 23
O 23 0 0 35 1
P 89 43 0 34 11
Q 55 67 9 53 3
R 14 12 34 23 4
S 9 11 53 1 1
T 7 34 23 2 2
U 0 53 1 3 0
V 47 23 32 4 3
W 22 1 11 1 4
X 34 0 3 0 65
Y 43 0 4 2 0
Z 67 0 1 0 0

 

[NARAYANK991]

Hi ,

You as the owner of the data need to decide what you wish to portray using the data ; for the rest of us these are exactly what you posted viz. counts.

An Excel chart is a way of portraying at first sight what the data does not ; whether a scatter chart is the right type or whether we should use a bubble chart is a decision that should be taken later.

First , can you list down a few things that the data tells you ?

Narayan