課程章節
培訓 · 第 13 單元:白板 · 第 13.3 章,共 4 章
13.3 圖表 3:32
插入圖表、為其提供資料、變更類型、選取資料、設定座標軸格式,並從 Excel 匯入圖表。
展示 Holarch 2.35。
您將學到
- 插入圖表,並在「圖表資料」中為其提供資料:手動輸入、貼上或從檔案匯入
- 變更圖表類型,包括堆疊與 100% 堆疊
- 在「選取資料」中切換列與欄,並排列數列順序
- 開啟圖表元素,並在「設定座標軸格式」中設定座標軸界限與單位
- 從 Excel 活頁簿匯入圖表
在 Bike-Share Dock 概念白板上新增一個用量圖表畫板:插入直條圖、編輯其資料並從 Excel 工作表匯入租借數字、在「變更圖表類型」圖庫中將它切換為堆疊直條圖(附 100% 堆疊、橫條圖、折線圖、圓形圖、環圈圖與散佈圖預覽)、在「選取資料」中重新排序並切換數列、在「圖表元素」中開啟資料標籤並移動圖例、在「設定座標軸格式」中設定數值座標軸的界限與單位,並以「從 Excel 匯入圖表」從 Excel 活頁簿匯入一張折線圖與一張圓形圖。
練習
在 Holarch 中於 Bike-Share Dock 上親自操作。
- 開啟本章的起始檔案與 Dock Concept 白板。按一下畫板列中的 +。
- 開啟表格和圖表並按一下直條圖。按兩下圖表,按一下從檔案匯入…,然後選擇您自己的一本含有一個標籤欄與兩個數字欄的活頁簿。
- 在圖表上按一下右鍵 → 變更圖表類型… → 堆疊直條圖 → 確定。
- 在圖表區段中按一下選取資料…,試著按兩次切換列/欄,將一個數列上移,然後按一下確定。
- 勾選資料標籤,將圖例設為頂端,按一下數值座標軸並設定最大值與主要。
- 按一下從 Excel 匯入圖表…,從一本含有圖表的活頁簿插入一張圖表。
當畫板上有一張附資料標籤、圖例在頂端且座標軸界限固定的堆疊直條圖,以及一張從 Excel 匯入的圖表時,即完成。
自我檢查
- 什麼時候 100% 堆疊圖比堆疊圖更好?
- 「切換列/欄」做什麼?
- 設定座標軸界限後,如何恢復為自動?
顯示答案
什麼時候 100% 堆疊圖比堆疊圖更好?
當比例比總數更重要時:每根長條都填滿整個高度,各區段顯示每個數列所占的部分。
「切換列/欄」做什麼?
它會對調數列與類別:列變成數列、欄變成類別,或反過來。
設定座標軸界限後,如何恢復為自動?
清空「設定座標軸格式」中的欄位。
延伸閱讀
文字稿
顯示文字稿 (旁白與畫面內容)
Introduction
Chapter three: charts. A whiteboard chart draws its own data, which you type, paste or import, and you format it the way you would in a spreadsheet.
In this chapter you build a board of usage charts for the dock.
A chart and its data
The charts get a board of their own. Click the plus in the Boards strip under the board: the new board opens as a second tab.
On screen: Boards strip → +.
Open the Tables and Charts panel, and click Column. The chart is added in the middle of the view, with sample data.
On screen: Tables and Charts panel → Column.
Double-click the chart to open Chart Data. Labels go in the first column and series names in the first row. You can type in the grid, add rows and series, or paste rows copied from a spreadsheet.
On screen: Double-click the chart → Chart Data.
Our rental figures are in a workbook. Click Import from File, and choose Dock Usage.
On screen: Import from File… → Dock Usage.xlsx.
The workbook has three sheets. Choose Rentals. The preview shows six months and two series, weekday and weekend. Click Use Imported Data, then Done.
On screen: Sheet: Rentals → Use Imported Data → Done.
Chart types
Right-click the chart, and choose Change Chart Type. The gallery shows your own data in every type.
On screen: Right-click → Change Chart Type….
Stacked column stacks each month's series, so the bar shows the total. One hundred percent stacked compares the shares. Bar turns the chart on its side, and line, pie, donut and scatter are here too.
On screen: Gallery: Stacked Column, 100% Stacked Column, Bar, Line, Pie, Donut, Scatter.
Choose Stacked Column, and click OK.
On screen: Stacked Column → OK.
Select Data
Select Data, in the Chart section, chooses what the chart shows. Switch Row and Column turns the months into the series and the series into the categories. Switch it back.
On screen: Chart section → Select Data… → Switch Row/Column, twice.
Legend entries lists the series. Select Weekend, and click Move Up: weekend now sits at the bottom of each stack, and keeps its color. Click OK.
On screen: Weekend → Move Up → OK.
Format the chart
Chart Elements turns the parts of the chart on and off. Tick Data labels, and set the legend position to Top.
On screen: Chart Elements → Data labels; Legend position: Top.
Click the numbers of the value axis to select the axis. A dashed box marks it, and the inspector shows Format Axis.
On screen: Click the value axis.
Set the maximum to three thousand, and the major unit to five hundred. Leave a box empty for automatic. Every change is one undo step.
On screen: Format Axis: Maximum 3000, Major 500.
Import charts from Excel
Charts made in Excel come in too. In the Tables and Charts panel, click Import Chart from Excel, and choose the workbook.
On screen: Import Chart from Excel… → Dock Usage.xlsx.
The dialog lists every chart in the workbook, with a preview, its sheet, its type and its series, and says what does not carry over. Tick the line chart and the pie chart, and click Insert.
On screen: Tick the line and pie charts → Insert 2 Charts.
They arrive selected, as whiteboard charts with their titles, colors and axes. Drag them below the first chart. You edit and format them like the one you made.
On screen: Drag the imported charts below the column chart.
Recap
To recap: insert a chart from the Tables and Charts panel, give it data in Chart Data, choose its type in the gallery, set its series in Select Data, format it with Chart Elements and Format Axis, and import charts from Excel.
In the next chapter, you link charts and tables to live spreadsheet cells, connect the board to the model and add clipart.