啞鈴圖
啞鈴圖用一條線連接兩個點,表示同一個項目的兩個數值,形狀就像啞鈴。兩點之間的距離就是差距,一眼就能看出哪些項目進步、哪些退步、差了多少,例如兩個年度的滿意度調查。
和分組長條圖相比,啞鈴圖更精簡,焦點集中在變化上。用 makechart.io 製作圖表時,貼上或上傳包含起點與終點兩欄的表格、對應欄位,就能下載 SVG 或 PNG 的資料視覺化成果。
設定資料
貼上、上傳資料,或用範例資料開始製作這張圖表。
資料格式
每一列是一個項目,一欄放起點數值、一欄放終點數值。每一列會畫成一個橫向的啞鈴,由上往下排列。
| 欄位 | 型態 |
|---|
name必填 | 文字、分類或順序 項目名稱,例如部門、國家或產品,顯示在類別軸上。 |
start必填 | 數值 第一個數值,例如去年或改變之前。 |
end必填 | 數值 第二個數值,例如今年或改變之後。 |
範例
| 部門 | 2023 | 2024 |
|---|
| 工程 | 68 | 79 |
| 設計 | 74 | 81 |
| 行銷 | 71 | 65 |
| 業務 | 58 | 66 |
| 客服 | 49 | 61 |
適合的使用時機
- 比較每個項目的兩個數值,例如前後對照、今年與去年、男性與女性。
- 在許多項目之間凸顯差距的大小與方向。
- 搭配排序,依變化幅度替項目排名。
不適合的情況
- 每個項目有兩個以上的數值,折線圖或斜率圖比較適合。
- 從零開始的絕對大小比差距更重要時,長條圖比較清楚。
- 差異非常小,兩個點會重疊在一起。
使用技巧
- 在「樣式」面板把 sort 的 field 設成 diff 或 abs,可依變化幅度排序;打開 delta 的 show 會標出每個差值。
- 把 line 的 mode 設成 delta,線條會依增加或減少上色;把 orientation 改成 vertical 就是垂直啞鈴圖。
相關圖表
Dumbbell Chart
A dumbbell chart shows two values for each item as two dots joined by a line, like a dumbbell. The distance between the dots is the gap, so you can see at once which items improved, which declined, and by how much, for example satisfaction scores in two survey years.
Compared with a grouped bar chart, it uses less ink and keeps the focus on the change. With the makechart.io chart generator, paste or upload a table with a start and end column, bind them, and download the data visualization as SVG or PNG.
Set up data
Paste, upload or pick sample data to make this chart.
Data format
One row per item, with one column for the starting value and one for the ending value. Each row becomes one horizontal dumbbell, listed from top to bottom.
| Field | Type |
|---|
namerequired | Text, category or order Item label, such as a department, country or product. Shown on the category axis. |
startrequired | Number First value, such as last year or before a change. |
endrequired | Number Second value, such as this year or after a change. |
Example
| department | 2023 | 2024 |
|---|
| Engineering | 68 | 79 |
| Design | 74 | 81 |
| Marketing | 71 | 65 |
| Sales | 58 | 66 |
| Support | 49 | 61 |
When to use
- Comparing two values per item, such as before and after, this year and last year, or men and women.
- Highlighting the size and direction of each gap across many items.
- Ranking items by how much they changed, using sort.
When not to use
- More than two values per item; a line chart or slopegraph handles more points.
- When the absolute size from zero matters more than the gap; a bar chart is clearer.
- Very small differences that make the two dots overlap.
Tips
- In the Style panel, set sort field to diff or abs to order items by their change, and turn on delta show to label each difference.
- Set line mode to delta to color lines by increase or decrease, or orientation to vertical for a vertical dumbbell chart.
Related charts