Database Reference
In-Depth Information
F I g u R e 12 -36 A chart with scale breaks
Adding all the countries of Europe creates a rather messy chart. You can tidy it
up by clicking the individual $2000 labels and deleting them. There is still data
missing, and to bring that missing data onto the chart, you need to change
the lower value for the upper reserve. This approach requires some manual
effort to get these values set to 100% correctly.
slICers And numBers TABles
You can dynamically set the scale break values if you have a numbers table
in your cube, use that numbers table as the data source for your slicer, and
then use that numbers table as your limit. This qualifies as an advanced
topic—more information can be found at http://markgstacey.net .
F I g u R e 12 -37 Changing
axis options
ExCEL: rADAr CHArTS
Excel radar charts are very easy to set up. From a new sheet, click Insert a
Pivot chart. Select the external data connection option, and choose the con-
nection to OECD_Data. If you need assistance, refer to Chapter 5.
Search WWH ::




Custom Search