课程章节
培训 · 课程 13. 白板 · 第 13.3 章,共 4 章
13.3 图表 3:32
插入图表,为其提供数据,更改类型,选择数据,设置坐标轴格式,并从 Excel 导入图表。
演示 Holarch 2.35。
您将学到
- 插入图表,并在“图表数据”中为其提供数据:键入、粘贴或从文件导入
- 更改图表类型,包括堆积和百分比堆积
- 在“选择数据”中切换行和列并排列系列顺序
- 打开图表元素,并在“设置坐标轴格式”中设置坐标轴边界和单位
- 从 Excel 工作簿导入图表
为 Bike-Share Dock 概念白板添加一块使用情况图表画板:插入柱形图,编辑其数据并从 Excel 工作表导入租借数据,在“更改图表类型”库中将其切换为堆积柱形图(附百分比堆积、条形、折线、饼图、环形图和散点图的预览),在“选择数据”中重新排序并切换系列,在“图表元素”中打开数据标签并移动图例,在“设置坐标轴格式”中设置数值轴的边界和单位,并用“从 Excel 导入图表”导入 Excel 工作簿中的折线图和饼图。
练习
在 Holarch 中基于 Bike-Share Dock 亲自完成此操作。
- 打开本章的起始文件和 Dock Concept 白板。单击“画板”栏中的 +。
- 打开 表格和图表 并单击 柱形图。双击图表,单击 从文件导入…,并选择您自己的、包含一列标签和两列数字的工作簿。
- 右键单击图表 → 更改图表类型… → 堆积柱形图 → 确定。
- 在 图表 部分中单击 选择数据…,尝试 切换行/列 两次,将一个系列上移,然后单击 确定。
- 勾选 数据标签,将图例设为 顶部,单击数值轴并设置 最大值 和 主要。
- 单击 从 Excel 导入图表…,并插入来自含图表工作簿的图表。
当画板上有带数据标签、顶部图例和固定坐标轴边界的堆积柱形图,以及一个从 Excel 导入的图表时,即完成练习。
自测
- 百分比堆积图何时优于堆积图?
- “切换行/列”有什么作用?
- 设置坐标轴边界后,如何恢复为自动边界?
显示答案
百分比堆积图何时优于堆积图?
当占比比总量更重要时:每根柱子都填满高度,各段显示每个系列所占的部分。
“切换行/列”有什么作用?
它交换系列和类别:行变为系列,列变为类别,反之亦然。
设置坐标轴边界后,如何恢复为自动边界?
清空“设置坐标轴格式”中的输入框。
延伸阅读
文字稿
显示文字稿 (旁白和屏幕内容)
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.