Name: 所有電子表格軟件都缺少的圖表 (The Chart Missing From ALL Spreadsheet Software)
Uploaded: 2025-06-17T14:50:25.000Z
Duration: 3 min 33 s

情態副詞

There are a bajillion different charts available in software like Excel or Numbers or Sheets or Mathematica or Plotly, but I recently discovered that pretty much all plotting apps, as far as I can tell, are missing an incredibly basic type of chart.

Excel 或 Numbers 或 Sheets 或 Mathematica 或 Plotly 等軟件中提供了數以億計的不同圖表，但我最近發現，就我所知，幾乎所有繪圖應用程序都缺少一種極其基本的圖表類型。

Consider this video my attempt to convince you it's a scandal these charts are missing, and my attempt to convince software developers to add them into their plotting software.

我試圖通過這段視頻來說服大家，這些圖表的缺失是個醜聞，同時我也試圖說服軟件開發人員將這些圖表添加到他們的繪圖軟件中。

Okay, so suppose you want to compare the climates of London, England, London, Ontario, and London, Kentucky.

好吧，假設你想比較英國倫敦、安大略省倫敦和肯塔基州倫敦的氣候。

Here's a table showing the average and seasonal high and low temperatures for each London.

下面的表格顯示了倫敦各地區的平均氣溫和季節性最高氣溫和最低氣溫。

If you wanted to plot this data by hand, you might imagine using a chart like this to show the range of temperatures, and allow you to see at a glance that the climate in London, England is less extreme than the other Londons.

如果您想手工繪製這些數據，您可以想象使用這樣的圖表來顯示溫度範圍，讓您一眼就能看出英國倫敦的氣候沒有其他倫敦那麼極端。

A bar chart makes more sense than, say, a point chart, since the temperatures in these Londons can by definition be in between the minimum and maximum ones in our table.

條形圖比點圖更有意義，因為根據定義，這些龍8國際娛樂城的溫度可能介於我們表格中的最低和最高溫度之間。

The problem is, you can't easily make a chart like this on a computer.

問題是，在電腦上製作這樣的圖表並不容易。

You can get close with an area chart, which plots the temperatures correctly, adds nice shading in between them, but also fills the area all the way down or up to the x-axis, which isn't right.

您可以使用面積圖來接近溫度，它可以正確繪製溫度，並在溫度之間添加漂亮的陰影，但也會使面積一直向下或向上填充到 x 軸，這是不對的。

You can get around the filling problem by creating a new table of the differences between the temperatures, and plotting that as a stacked area chart.

您可以創建一個新的溫度差異表，並將其繪製成疊加面積圖，從而解決填充問題。

But it still doesn't make sense to use a chart that draws connecting lines in a situation like this where we're talking about discrete geographic locations.

但在這種情況下，如果我們討論的是離散的地理位置，使用繪製連接線的圖表還是沒有意義的。

You can also get close with a stacked bar chart, or stacked column chart depending on whether you think bars can be both horizontal and vertical, or if you think vertical bars have to be called columns.

您還可以使用堆疊條形圖或堆疊柱形圖，這取決於您是否認為條形圖既可以是水準的，也可以是垂直的，或者您是否認為垂直條形圖必須稱為柱形圖。

Anyway, a stacked bar column chart separates out the cities correctly, but incorrectly adds the temperatures together, hence stacked.

總之，堆疊條形柱狀圖能正確地將城市分開，但卻錯誤地將溫度加在一起，是以是堆疊的。

The columns are stacked together appropriate to the name, but it's not what we want.

列堆疊在一起與名稱相符，但這並不是我們想要的。

You can get around the stacking problem by again creating a table of the differences between the temperatures, but then it still fills down to 0 even if you want the bars to start at some other number.

您可以通過再次創建一個溫度差表來解決堆疊問題，但這樣一來，即使您想讓條形圖以其他數字為起點，它仍然會填充到 0。

And the negative values are a total nightmare, since stacked column charts by default plot things from 0, and if you enter a negative number for the first value to try to get it to start below 0, it plots that amount below 0, but then measures the positive numbers up from 0 anyway, and not from the negative number?

負值簡直就是噩夢，因為堆疊式柱狀圖默認是從 0 開始繪製的，如果你為第一個值輸入一個負數，試圖讓它從 0 以下開始繪製，它就會在 0 以下繪製這個數值，但隨後無論如何都會從 0 開始向上測量正數，而不是從負數開始？

This is because stacked column charts are meant for things like keeping inflows and outflows separate, like you bought 5 cats and sold 2 and you want the total length of bars to represent the total number of transactions, 7, and not the final number of cats, 3.

這是因為堆疊式柱狀圖適用於將流入和流出分開的情況，比如你買了 5 只貓，賣了 2 只，你希望柱狀圖的總長度代表交易總數 7，而不是最終的貓數 3。

The only reasonable way I've found to deal with negative numbers in stacked column charts is just to add a really big number to all the temperatures so they're not negative anymore, make the chart, and then photoshop the y-axis labels to remove the big number, which is ridiculous.

我發現在堆疊柱狀圖中處理負數的唯一合理方法就是在所有溫度上加一個非常大的數字，這樣它們就不再是負數了，然後製作圖表，再用 Photoshop 把 Y 軸標籤上的大數字去掉，這太荒謬了。

What we're actually looking for is something called a range chart, where you enter the top and bottom values of the range, and then the program draws that for you.

實際上，我們要找的是一種叫做範圍圖的東西，在這種圖表中，你可以輸入範圍的頂值和底值，然後程序會為你繪製。

Specifically, we want a stacked range bar chart, where you can enter multiple numbers including negative numbers, and then draw bars between them.

具體來說，我們想要一個堆疊範圍條形圖，在這裡您可以輸入多個數字，包括負數，然後在它們之間繪製條形圖。

Here are a few more examples of data that really would benefit from being visualized with a stacked range bar chart.

下面還有一些數據示例，使用堆疊範圍條形圖可以使數據更加直觀。

But first, I'm giving away all my drawings on Patreon right now.

但首先，我現在正在 Patreon 上贈送我所有的畫作。

There are still some left, so you have until the end of November to support MinutePhysics at the special relativity tier or above, and I will send you an original drawing.

現在還剩下一些，所以您可以在 11 月底之前支持 MinutePhysics 的狹義相對論或更高級別，我將給您寄一張原畫。

If you have someone else in your life who also likes MinutePhysics, you can also give a Patreon membership as a gift, so they can get a drawing as well.

如果您的生活中還有其他人也喜歡 MinutePhysics，您也可以將 Patreon 會員資格作為禮物送給他們，這樣他們也可以獲得抽獎機會。

Thank you so much, and back to the benefits of stacked range bar charts.

非常感謝，現在回到疊加範圍條形圖的好處上來。

Really any chart where the x-axis is a discrete set of things and the y-axis is a range that can go below and above zero is a candidate for this type of chart, like if you wanted to plot the range of latitudes of each of the continents, or show when twilight, dusk, and daytime are at a given location.

實際上，只要 x 軸是一組離散的事物，而 y 軸是一個可以低於或高於零的範圍，那麼任何圖表都可以使用這種類型的圖表，比如您想繪製各大洲的緯度範圍，或者顯示某個地點的黃昏、黃昏和白天時間。

Or compare percentiles for student grades in different classes.

或者比較不同班級學生成績的百分位數。

Plotting the average daily low and average daily high temperatures for each month, along with the average monthly low and high temperatures and the record monthly low and high temperatures across a year, gives you a picture of the seasonal variation in temperature for a particular location.

將每月的日平均最低氣溫和日平均最高氣溫，以及全年的月平均最低氣溫和最高氣溫以及月最低氣溫和最高氣溫記錄繪製成圖，就可以瞭解特定地點的氣溫季節變化情況。

Yes, you can do this with a stacked area chart, but that makes less sense than stacked columns because area implies some sort of continuity when to create the data you are literally binning or averaging by month.

是的，您可以使用堆疊區域圖來實現這一點，但這比堆疊列圖更不合理，因為區域圖意味著某種連續性，而創建數據時，您實際上是按月進行分選或平均。