Database Reference
In-Depth Information
may need to compare the total sales of each store within a region to each
other, as well as to a target that is set for each store, and quite possibly the
store average as well.
BulleT grAPhs
Bullet graphs are the invention of Stephen Few, and his specification for
what they should look like can be found online at
www.perceptualedge.
com/articles/misc/Bullet_Graph_Design_Spec.pdf
. As always,
Stephen Few is very fond of monochrome, so you may want to spruce up
the design by using colors rather than gray scale.
The bullet graph in Figure 15-10 shows 2011 unemployment rates (the blue bar
for each country) against a country-specific target (the black line—note that
I made up the target), as well as against the overall target bands (the colored
band at the back). Using a graph spread across the 20 columns in Excel is not
necessary, but does give a nice visual cue to exactly how far the bullet graph
is along the bands.
FI g u R e 15 -10
Using a bullet graph
Ease of Development
rEPorTING TooL
PrEDEFINED CHArT TyPE
EASE oF DEVELoPMENT
Excel
No
PerformancePoint
No
Power View
No
Reporting Services
No
Silverlight/HTML5
N/A
