PLACING CHARTS ON THE DASHBOARD
Both worksheets and dashboard objects can be placed on the dashboard by dragging the items from the Dashboard pane to the area labeled Drop Sheets Here.
Consider the workbook from Figure 8.1, which has three sheets: Sales
, Forecast
, and Map
. (If you would like to follow along, take a peek ahead at Figure 8.5 and create each of the three charts in a separate sheet. You should be able to re‐create these using the Superstore dataset, based on what you have learned in previous chapters.)
Starting with a blank dashboard, begin by placing the main worksheet (Sales
in this case) onto the canvas. Then, add the second sheet (Forecast
) in the same manner. Typically, the main sheet should sit in the top‐left corner, which is where the eye tends to look first (at least, in cultures that read from left to right). So, place the second sheet below the first.
As shown in Figure 8.3, the area where the sheet will drop is shown in grey before you release the...