課程章節
培訓 · 第 13 單元:白板 · 第 13.4 章,共 4 章
13.4 即時資料、模型項目與美工圖案 3:17
將儲存格貼上為即時表格、將圖表連結到試算表儲存格、將形狀連結並轉換為模型項目,以及加入美工圖案。
展示 Holarch 2.35。
您將學到
- 將 Excel 的儲存格貼上為即時試算表表格
- 在「選取資料」中將圖表連結到試算表範圍
- 在試算表中變更數值,看畫板隨之更新
- 將形狀連結到模型項目,並將形狀轉換為新項目
- 尋找美工圖案、加上星號並插入
完成 Bike-Share Dock 概念白板:將 Excel 中的停車站狀態儲存格貼上為即時試算表表格,以「選取資料」將一張橫條圖連結到同樣的儲存格,在試算表中變更一個數字,看表格與圖表隨之更新,將一個形狀連結到模型中的資產,並將另一個形狀轉換為新資產,最後從「美工圖案」面板加入一張圖片。
練習
在 Holarch 中於 Bike-Share Dock 上親自操作。
- 開啟本章的起始檔案與 Dock Concept 白板。按一下畫板列中的 +。
- 在 Excel 中複製一小塊含標題列的儲存格。按一下畫板,按 ⌘V / Ctrl+V(或 Ctrl+V),選擇即時試算表,然後按一下貼上。
- 插入橫條圖,開啟選取資料… → 連結到試算表範圍…,選擇新的試算表,輸入範圍並按一下連結,然後按確定。
- 按兩下表格,在試算表中變更一個數字,然後透過其編輯器分頁回到畫板。
- 在 Board 1 上選取 Rental Kiosk 形狀,按一下連結到…,然後選擇 Rental Kiosk 資產。選取 Rider,按一下轉換為模型…,選擇 Asset,然後按一下轉換。
- 開啟美工圖案,搜尋
bicycle,為一張圖片加上星號,然後按一下它將其插入。
當表格與圖表顯示您變更的數字、兩個形狀都帶有類別徽章,且畫板上有一張腳踏車圖片時,即完成。
自我檢查
- 將儲存格貼上為「圖表」與貼上為「即時試算表」有什麼不同?
- 圖表如何跟隨試算表儲存格?
- 「連結到…」與「轉換為模型…」有什麼不同?
顯示答案
將儲存格貼上為「圖表」與貼上為「即時試算表」有什麼不同?
「圖表」保留數值的副本,不會改變。「即時試算表」會以這些儲存格建立一份試算表,並以會隨之變化的即時表格顯示它們。
圖表如何跟隨試算表儲存格?
在「選取資料」中以「連結到試算表範圍…」連結;之後圖表就會依據該範圍繪製。
「連結到…」與「轉換為模型…」有什麼不同?
「連結到…」將形狀繫結到已存在的項目。「轉換為模型…」則從形狀建立一個以其文字命名的新項目,並加以連結。
延伸閱讀
文字稿
顯示文字稿 (旁白與畫面內容)
Introduction
Chapter four: live data, model items and clipart. A board can show figures that stay current, stand for items of the model, and use ready-made pictures.
In this chapter you finish the dock concept board.
Live data from pasted cells
Live data gets a board of its own. Click the plus in the Boards strip.
On screen: Boards strip → +.
The dock status is kept in a workbook: each station's docks, and the bikes available now. In Excel, select the cells and copy them.
On screen: Dock Status.xlsx.
Click the board, and press Command V, or Control V. Holarch asks how to paste the cells. Choose Live spreadsheet, and click Paste.
On screen: Click the board → ⌘V / Ctrl+V → Live spreadsheet → Paste.
Holarch creates a spreadsheet that holds the cells, and shows them on the board as a live table. Drag the table to the left.
On screen: The live table → drag it left.
A chart can follow the same cells. In the Tables and Charts panel, click Bar, and drag the chart beside the table.
On screen: Tables and Charts → Bar → drag it right.
Open Select Data, and click Link to Spreadsheet Range. Choose the new spreadsheet, type A1 to C5 as the range, and click Link.
On screen: Select Data… → Link to Spreadsheet Range… → A1:C5 → Link.
Select Data now names the linked range, and the chart shows the stations' docks and bikes. Click OK.
On screen: Linked range → OK.
The board follows the source
Now change a figure at its source. Double-click the table: its spreadsheet opens, with the cells selected.
On screen: Double-click the table → the spreadsheet.
Two more bikes are back at Riverside. In the Name Box, type C3 and press Enter, then type 6 in the formula bar, and press Enter.
On screen: Name Box C3 → formula bar 6 → Enter.
Go back to the board with its editor tab. The table and the chart already show six bikes at Riverside.
On screen: Editor tab → the board; the new value.
Model items on the board
Shapes on a board can stand for items of the model. Open Board 1, and select the rental kiosk.
On screen: Board 1 → select Rental Kiosk.
In the inspector's Model section, click Link to, search for Rental Kiosk, and choose the asset.
On screen: Link to… → Rental Kiosk (Asset).
The shape shows a badge, and the inspector names the linked asset. Click its name to see the asset's details in the side panel.
On screen: Badge; Model section → the asset.
A shape can also become a new item. Select the rider, and click Convert to Model. Choose Asset as the class, keep the name, and click Convert.
On screen: Rider → Convert to Model… → Asset → Convert.
The rider is now an asset of the model, linked to its shape, and listed in the Database with the other assets.
On screen: The linked Rider.
Clipart
Last, the Clipart panel: thousands of pictures and icons for concept graphics. Open it, and search for bicycle.
On screen: Clipart panel → search bicycle.
The star on a picture adds it to your favorites. Click a picture to add it to the board, and drag it below the rider.
On screen: Star → click the picture → drag it beside the rider.
Recap
To recap: paste cells as a live table, link charts to spreadsheet ranges in Select Data, link or convert shapes in the Model section, and add pictures from the Clipart panel.
That completes the whiteboard track. You can now sketch a concept with shapes and lines, chart its figures, keep them live, and tie the board to the model.
On screen: Track complete card, then end card.