Skip to Content

登陆/注册

如何在Excel中创建时间轴

下载PDF文件

共同创作者是 wikiHow员工

下载PDF文件

时间轴是2013版Excel中引进的新功能。它允许用户轻松选取Excel中的数据透视表里的一段时间。如果你的Excel中有数据透视表及日期，你可以创建可视化的时间轴。

步骤

下载PDF文件

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ac\/Create-a-Timeline-in-Excel-Step-1-Version-3.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ac\/Create-a-Timeline-in-Excel-Step-1-Version-3.jpg\/v4-728px-Create-a-Timeline-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

为了使用时间轴，你的数据必须以透明数据表来呈现。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/ce\/Create-a-Timeline-in-Excel-Step-2-Version-3.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/ce\/Create-a-Timeline-in-Excel-Step-2-Version-3.jpg\/v4-728px-Create-a-Timeline-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

在顶部菜单栏上，就会显示出“数据透视表工具”。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/65\/Create-a-Timeline-in-Excel-Step-3-Version-3.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/65\/Create-a-Timeline-in-Excel-Step-3-Version-3.jpg\/v4-728px-Create-a-Timeline-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

这会在表格中打开一个可以编辑数据的窗口。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1e\/Create-a-Timeline-in-Excel-Step-4-Version-3.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Create-a-Timeline-in-Excel-Step-4-Version-3.jpg\/v4-728px-Create-a-Timeline-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

在你点击的位置上，会出现一个对话框。警告：输入的文本数据是不会被识别的。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ec\/Create-a-Timeline-in-Excel-Step-5-Version-3.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ec\/Create-a-Timeline-in-Excel-Step-5-Version-3.jpg\/v4-728px-Create-a-Timeline-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

一个可以让你浏览时间轴的对话框会出现。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1b\/Create-a-Timeline-in-Excel-Step-6-Version-3.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1b\/Create-a-Timeline-in-Excel-Step-6-Version-3.jpg\/v4-728px-Create-a-Timeline-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

根据你所选择的信息，选择对应的过滤方式（按月、年或季度）。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b2\/Create-a-Timeline-in-Excel-Step-7-Version-3.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b2\/Create-a-Timeline-in-Excel-Step-7-Version-3.jpg\/v4-728px-Create-a-Timeline-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

当你点击时间轴中的月份之后，数据透视表就会显示该月的所有数据。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/78\/Create-a-Timeline-in-Excel-Step-8-Version-3.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Create-a-Timeline-in-Excel-Step-8-Version-3.jpg\/v4-728px-Create-a-Timeline-in-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

点击并拖到滑块，就可以扩大数据的选择范围。

广告

你可能还喜欢

广告

关于本wikiHow

共同创作者是 :

wikiHow专职作家

这篇文章由我们训练有素的编辑和研究团队共同创作，他们对文章的准确性和全面性进行了验证。

wikiHow的内容管理团队会严密监督编辑人员的工作，确保每篇文章都符合我们的高质量标准要求。这篇文章已经被读过36,494次。

分类: Office

印度尼西亚语

打印

本页面已经被访问过36,494次。

这篇文章对你有帮助吗？

广告

-

-

357

.mwimg a.image{display:none}#header_logo{display:none}#cse-search-box{display:none}#cse-search-box-noscript{display:block !important}#cse-search-box-noscript .cse_q{color:#FFF;background-color:#B3CE9C}.wh_search .cse_q{width:88%}#mw-mf-main-menu-button{display:none;visibility:hidden}.header .search{display:none}#search_footer .cse_sa{background-image:url(/extensions/wikihow/mobile/images/white_mag.png);background-size:22px}.related_box{display:block;background:#EEE;border:5px solid #FFF;vertical-align:bottom;width:127px;background-size:180px;float:left;height:120px;position:relative}.related_box p{line-height:15px !important;font-size:13px;background-color:rgba(67,95,44,.4);color:#FFF;font-weight:bold;padding:8px;margin:0 !important;position:absolute;bottom:0}#noscript_header_logo{display:table-cell;vertical-align:middle;background-position:50% 77%;background-repeat:no-repeat;background-image:url(/extensions/wikihow/mobile/images/wikihow_logo_230.png);background-size:105px;width:auto;height:51px;padding:0 14px}.articleinfo{display:none}#iorg_free_data{z-index:50;width:100%;position:fixed}#ara_recommendations{display:none}

Design a Mobile Website

View Site in Mobile | Classic

Share by: