如何在Excel中创建时间轴

下载PDF文件
共同创作者是 wikiHow员工

下载PDF文件

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

步骤

下载PDF文件
  1. {"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>"}
    为了使用时间轴，你的数据必须以透明数据表来呈现。
  2. {"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>"}
    在顶部菜单栏上，就会显示出“数据透视表工具”。
  3. {"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>"}
    这会在表格中打开一个可以编辑数据的窗口。
  4. {"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>"}
    在你点击的位置上，会出现一个对话框。警告：输入的文本数据是不会被识别的。
  5. {"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>"}
    一个可以让你浏览时间轴的对话框会出现。
  6. {"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>"}
    根据你所选择的信息，选择对应的过滤方式（按月、年或季度）。
  7. {"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>"}
    当你点击时间轴中的月份之后，数据透视表就会显示该月的所有数据。
  8. {"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>"}
    点击并拖到滑块，就可以扩大数据的选择范围。
    广告

你可能还喜欢

如何
取消保护Excel工作表
如何
对比两个Excel文件
如何
在EXCEL中取消隐藏行
如何
在Word中插入页码
如何
压缩PPT文件的大小
如何
在Microsoft Excel中插入超链接
如何
在Excel中复制公式
如何
在微软Word里插入超链接
如何
word文件转换为pdf文件
如何
在Word里重新排列页面
如何
在Excel中自动填充数字
如何
在Excel中创建日历
如何
将Word文档转换为PowerPoint
如何
用EXCEL创建货币转换器
广告

关于本wikiHow

其他语言
本页面已经被访问过35,972次。

这篇文章对你有帮助吗？

广告