Database Reference
In-Depth Information
a pane like the one in Figure 11-39; in earlier versions of Excel, you see pop-up
window. Click the Paint icon, then choose Marker, and choose a series marker
in Marker options—the default Square and size 5 will work nicely—and show
the values of Population levels on the chart.
The final piece to this chart is showing interpolated values. This is where Excel
truly shines over the other tools. Right-click on the line chart, and click Add
Trendline—all the default values are fine (although you may want to play with
the forecast feature!). Click OK. You see the final chart shown in Figure 11-40.
You would, of course, finish of by formatting the axes appropriately.
FIguRe 11-39 The Format
Data Series pane in Excel
2013
F I g u R e 11 - 4 0 An interpolated population chart
A DrILLABLE LINE CHArT IN PPS
In PerformancePoint, set up a data connection as described in Chapter 7,
making sure to set up the time dimension correctly. You use the OECD_Data
model that you setup in Chapter 7, and create an analytic chart. Right-click
the library and click New a Report. Choose Analytic Chart and then choose
the data source you created. In the chart design screen, drag the YMD hier-
archy from DimDate into the Bottom Axis column. Drag ReserveValue from
Measures into the series. Finally, right-click the chart and select Report Type a
Line Chart with Markers.
To choose the appropriate data, click the All value on the bottom axis and
then right-click next to it so you can select Filter a Filter Empty Axis Items.
At this point, you see a chart such as the one in Figure 11-41.
Search WWH ::




Custom Search