excel散点图_Excel圣诞节祝福和散点图-CSDN博客

excel散点图

Last week, someone tweeted a wish for a new Excel Chart type:

上周，有人在推特上发布了一种新的Excel Chart类型的愿望：

"It's 2010... come on Excel... all I want for Christmas is a 3d scatter chart, it's not too hard! I don't want to have to fire up Processing!"
“现在是2010年...来吧，在Excel上...圣诞节我想要的只是一张3d散点图，这并不难！我不想启动处理程序！”

If you could have one new Excel feature, is that what you'd ask for? Maybe not, but if that tweeter reads to the end of this blog post, there's a link that will help.

如果您可以拥有一项新的Excel功能，那就是您要的吗？也许不是，但是如果该高音扬声器读到这篇博客文章的末尾，那么会有一个链接会有所帮助。

折线图与散点图 (Line Chart Vs Scatter Chart)

Can you spot the differences between an Excel line chart and an XY (scatter) chart? They can look very similar, as in the monthly sales example shown below.

您可以发现Excel折线图和XY(散点图)之间的区别吗？它们看起来非常相似，如下面所示的每月销售示例。

Did you recognize the scatter chart as the one on the right? There are slight differences in the X axis, and how the data points line up with the axis labels.

您是否知道散点图是右侧的散点图？ X轴以及数据点与轴标签的排列方式略有不同。

However, if the month numbers aren't listed in order, the difference between a line chart and scatter chart become more obvious.

但是，如果未按顺序列出月份数字，则折线图和散点图之间的差异会变得更加明显。

The line chart, at the left, treats the month numbers as text labels.

左侧的折线图将月份数字视为文本标签。

The numbers on the X axis appear in the order they're listed in the chart's source data.
X轴上的数字按在图表源数据中列出的顺序显示。
Each data point is matched to its label, in the order they're listed in the chart's source data.
每个数据点都按其在图表源数据中列出的顺序与其标签匹配。
The line chart is blissfully unaware of any values attached to the labels.
折线图非常高兴地不知道标签上附加的任何值。

The scatter chart, at the right, recognizes the numeric values in column A of the chart's source data. As a result, the chart looks like a wacky connect-the-dots puzzle.

右侧的散点图可识别图表源数据的A列中的数值。结果，该图表看起来像是一个古怪的点点拼图。

The numbers on the X axis are in correct numeric order.
X轴上的数字按正确的数字顺序排列。
Each data point is matched to its label's value. The line goes from 1 to 5, back to 3, then 4, 2 and 6.
每个数据点都与其标签的值匹配。该行从1到5，再回到3，然后是4、2和6。
The scatter chart recognizes the numeric values attached to the labels.
散点图可识别粘贴在标签上的数值。

折线图与日期散点图 (Line Chart Vs Scatter Chart For Dates)

One type of numeric label that a Line chart DOES recognize is a date. If the numbers in column A are changed to dates, the Line chart plots them correctly, even if the months are not listed in chronological order.

折线图可以识别的一种数字标签是日期。如果将A列中的数字更改为日期，则折线图将正确地绘制它们，即使未按时间顺序列出月份。

For example, March is near the bottom of the source data, but is the third data point in the Line chart.

例如，March在源数据的底部附近，但在折线图中是第三个数据点。

The scatter chart formats the numbers on the X axis as dates, but shows them in 50-day intervals, instead of showing the first date of each month, as the Line chart does. The scatter chart plots the dates in the order listed, unlike the line chart.

散点图将X轴上的数字格式化为日期，但以50天为间隔显示它们，而不是像折线图那样显示每个月的第一个日期。与折线图不同，散点图按列出的顺序绘制日期。

When it recognizes dates in the labels column of the source data, a Line chart uses a Date axis, instead of a Text axis. You can allow Excel to automatically select the best axis type, or manually select the axis type that you prefer.

当它在源数据的标签列中识别出日期时，折线图将使用日期轴而不是文本轴。您可以允许Excel自动选择最佳的轴类型，或手动选择所需的轴类型。

有关Excel散点图的更多信息 (More on Excel Scatter Charts)

Jon Peltier, the grand master of Excel charts, has summarized the differences between scatter charts and line charts, and includes a table that compares their features. He has also written about the different axis types, in X Axis: Category vs Value.

Excel图表的大师Jon Peltier总结了散点图和折线图之间的区别，并包括一个比较它们功能的表。他还用X轴：Category vs Value编写了有关不同轴类型的文章。

And finally, for the tweeter who wants a 3D scatter chart for Christmas, there's Andy Pope's 3D XY Scatter Chart -- until Microsoft builds one into Excel. ___________

最后，对于想要在圣诞节期间使用3D散点图的高音扬声器，还有安迪·波普(Andy Pope)的3D XY散点图 -直到Microsoft将其内置到Excel中。 ___________