• Home
  • Tools dropdown img
    • Spreadsheet Charts

      • ChartExpo for Google Sheets
      • ChartExpo for Microsoft Excel
    • Power BI Charts

      • Power BI Custom Visuals by ChartExpo
    • Word Cloud

  • Charts dropdown img
    • Chart Category

      • Bar Charts
      • Circle Graphs
      • Column Charts
      • Combo Charts
      • Comparison Charts
      • Line Graphs
      • PPC Charts
      • Sentiment Analysis Charts
      • Survey Charts
    • Chart Type

      • Box and Whisker Plot
      • Clustered Bar Chart
      • Clustered Column Chart
      • Comparison Bar Chart
      • Control Chart
      • CSAT Survey Bar Chart
      • CSAT Survey Chart
      • Dot Plot Chart
      • Double Bar Graph
      • Funnel Chart
      • Gauge Chart
      • Likert Scale Chart
      • Matrix Chart
      • Multi Axis Line Chart
      • Overlapping Bar Chart
      • Pareto Chart
      • Radar Chart
      • Radial Bar Chart
      • Sankey Diagram
      • Scatter Plot Chart
      • Slope Chart
      • Sunburst Chart
      • Tornado Chart
      • Waterfall Chart
      • Word Cloud
    • Google Sheets
      Microsoft Excel
  • Services
  • Pricing
  • Contact us
  • Blog
  • Support dropdown img
      • Gallery
      • Videos
      • Contact us
      • FAQs
      • Resources
    • Please feel free to contact us

      atsupport@chartexpo.com

Categories
All Data Visualizations Data Analytics Surveys
Add-ons/
  • Google Sheets
  • Microsoft Excel
  • Power BI
All Data Visualizations Data Analytics Surveys
Add-ons
  • Google Sheets
  • Microsoft Excel
  • Power BI

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok

ChartExpo Survey



Home > Blog > Microsoft Excel

How to Create & Use Time Series Chart in Excel?

You have data you’ve been tracking over time. And you’re tasked to explain its trend and also provide a forecast.

What’s the chart to go for?

Yes, you guessed right. It’s the Time Series Chart in Excel. The chart is suitable in this scenario because time and dates are continuous, categorical data.

time series chart excel

If you want to craft a compelling data story that provides actionable insights into trends, outliers, and other shifts, use Time Series charts. And this is because they’re straightforward to read and understand.

Remember, simplicity is always at the core of every persuasive narrative.

There’s no doubt that people don’t like to be subjected to cognitive overload. So, the simpler the message, the more compelling it becomes.

Excel lacks ready-to-use Time series Charts. 

You don’t have to do away with the Excel spreadsheet. Supercharge its usability by installing a particular third-party application into your spreadsheet to access a ready-to-use and visually appealing Time Series Graph.

In this blog, you’ll learn the following:

Table of Content:

  1. What is a Time Series Chart in Excel?
  2. Why Should You Use the Time Series Chart?
  3. Understanding Time-Series Data
  4. Components of a Time Series Chart in Excel
  5. Variable Types for Time-Series Plots
  6. Time-Series Plot vs. Time-Series Graphs: Key Differences
  7. Types of Time-Series Graphs in Excel for Data Visualization 
  8. How to Create a Time Series Chart in Excel? 
  9. When To Avoid Using a Time Series Graph?
  10. Wrap Up

Before delving into the how-to guide, we’ll address the following question: what is a Time Series Chart?

What is a Time Series Chart in Excel?

Definition: A Time Series Chart in Excel is a visualization design that illustrates data points at successive intervals of time.

Each point in a Time Series Chart in Excel corresponds to a time and variable under study. The horizontal axis of the chart or graph plots time increments while the vertical displays the key data point understudy.

However, if the data presented in a stacked waterfall format includes a time dimension, it could potentially serve as a form of a Time Series Chart, albeit with a different visual representation. In such cases, it’s essential to ensure that the stacked waterfall chart effectively communicates the temporal aspect of the data.

Why Should You Use the Time Series Chart?

Use the Time Series Chart in Excel to display changes in metrics (plotted on the vertical axis) and continuous values, such as time (plotted on the horizontal).

To get the insights, check for line segments moving consistently from left to right and evaluate their respective slopes (rate of change).

On the horizontal axis, use a variable that depicts continuous attributes at regular intervals of measurement. And this variable should be a temporal one, generating an observation every minute, hour, day, week, or month.

Use a variable in each of the intervals defined by the horizontal-axis variable on the vertical axis. Often, this can be a statistical summary, such as:

  • Count
  • Average

Understanding time-series data

Time-series data is a sequence of data points collected over time at regular intervals. It’s unique because the order of data points matters, allowing for the analysis of trends, patterns, and cycles.

Key characteristics include temporal order, where data is chronologically arranged, and autocorrelation, where current values are influenced by past values.

This type of data is essential for forecasting, making a graph from a table, and identifying underlying trends in various fields such as finance, economics, and environmental studies.

Components of a Time Series Chart in Excel

  1. Trend component

Analyzing trends is critical in predicting future movements.

The trend shows an increase or decrease of a key variable over a certain period. Not all increases or decreases occur simultaneously.

  1. Seasonal Component

This is the variation in a particular variable due to some predetermined patterns over time.

You can use the Time Series graph examples to display insights into the commodity price quotes, interest rates, exchange rates, stock prices, and so on.

Variable Types for Time-Series Plots

Time Variable

The time variable is a special kind of independent variable that represents the temporal component of the data. This variable is plotted on the x-axis in a time-series plot and can take different forms such as:

  • Continuous Time: This is represented by a smooth, continuous timeline, often seen in data collected at every instant or very short intervals, like stock prices or heart rate monitoring.
  • Discrete Time: Here, time is represented at specific intervals, such as daily, weekly, or monthly data. Examples include monthly sales figures or quarterly GDP.

Dependent Variable

The dependent variable in time-series analysis is the variable being observed or measured over time. This is typically plotted on the y-axis and can be of different types, including:

  • Quantitative Variables: These are numerical variables that can be measured and include things like temperature, sales revenue, or the number of units produced.
  • Categorical Variables: Though less common in time-series plots, categorical variables may be used when data is aggregated or averaged over time, such as categorizing stock performance as “high” or “low.”

Time-Series Plot vs. Time-Series Graphs: Key Differences

Time-Series Plot

A time-series plot is a specific type of graph where data points are plotted against time. The focus is on visualizing the values of a variable over time, often using a line to connect consecutive points. It’s used to identify trends, patterns, and anomalies over time.

Time-Series Graph

A time-series graph is a broader term that encompasses any graphical representation of time-series data. It can include line plots, bar graphs, or even scatter plots, depending on the nature of the data and the analysis required. Time-series graphs are used to visually explore the relationships and patterns within the data over time.

Types of Time-Series Graphs in Excel for Data Visualization

There are 4 types of Time Series Chart in Excel, namely:

  1. Dual Axis Line Chart
  2. Multi-Axis Line Chart
  3. Sentiment Trend Chart
  4. Area Line Chart

Let’s discuss these charts in detail.

  1. Dual Axis Line Chart

The Dual Axis Line Graph is one of the best Time Series Graphs for comparing two data sets for a presentation.

dual axis line chart 080

The visualization design uses two axes to easily illustrate the relationships between two variables with different magnitudes and scales of measurement, such as in a Multi-Axis Chart in Excel.

The relationship between two variables is referred to as correlation. The Dual Axis Line Chart illustrates plenty of information using limited space, so you can discover trends you may have otherwise missed.

  1. Multi-Axis Line Chart

Plotting multiple metrics in one graph is possible if you use a Multi-Axis Line Chart.

multi axis line chart 080

This chart visualizes trends and relationships in various datasets. It’s made up of various data points connected using line segments, where each point represents a single value. Use this chart to visualize continuous data like prices over time.

  1. Sentiment Trend Chart

A Sentiment Trend Chart is one of the Time Series charts in Excel you can use to display the target market’s opinion of your offerings.

sentiment trend chart 080

The chart is a must-have, especially if your goal is to show the growth and decline of key variables. The line curve in the chart shows the overall pattern and trend of a key variable over a specified period.

  1. Area Line Chart

An Area Line Chart is a visualization design that uses a line graph and a filled area to display patterns and trend insights into key data points in a specified period.

area line chart 080

The visualization design is ideal if your goal is to display trends. Besides, it’s one of the best charts for tracking performance in a specified period.

The visualization design is amazingly easy to read and interpret. Furthermore, its minimalist design ensures no insight is obscured.

In the coming section, we’ll take you through how to create a Time Series Chart in Excel.

You don’t want to miss this.

How to Create a Time Series Chart in Excel?

Excel is a trusted data visualization tool because it’s familiar and has been there for decades.

However, the spreadsheet application lacks ready-made Time Series Charts, such as Dual Axis Line Graphs.

We understand switching tools is not an easy task.

This is why we’re not advocating you ditch Excel in favor of other expensive data visualization tools.

There’s an easy-to-use and amazingly affordable visualization tool that comes as an add-in you can easily install in your app to access a ready-made Time Series Chart in Excel. The tool is called ChartExpo.

So, what is ChartExpo?

ChartExpo is an incredibly intuitive add-in for Excel which you can easily install in your Excel without watching hours of YouTube tutorials.

With many ready-to-go visualizations, including Waterfall charts in Excel, the Time Series Chart Excel generator turns your complex, raw data into compelling, easy-to-digest, visual renderings that tell the performance review stories in real-time.

  • ChartExpo is cloud-hosted, which makes it extremely light. You have a 100% guarantee that your Excel won’t be slowed down.
  • You can export your insightful, easy-to-read, and intuitive charts in JPEG, PDF, SVG, and PNG formats.
  • ChartExpo add-in is only $10 a month after the end of the trial period.
  • The app has an in-built library with a lot of easy-to-customize and ready-made charts in Excel for your data stories.
  • ChartExpo also lets you edit and customize the charts in Excel.

In the coming section, we’ll take you through how to use ChartExpo in your Excel.

You don’t want to miss this!

Example

This section will use the Area Line Graph (one of the Time Series Chart variants) to display insights into the table below.

Months Current Previous
Jan 90 70
Feb 60 80
Mar 40 30
Apr 70 60
May 80 90
Jun 75 60
Jul 40 30
Aug 60 70
Sep 90 80
Oct 50 70
Nov 70 60
Dec 50 40
  • To install ChartExpo into your Excel, click this link.
  • Open the worksheet and click the Insert button to access the My Apps.
insert chartexpo in excel
  • Select ChartExpo add-in and click the Insert.
open chartexpo in excel
  • Look for “Area Line Chart” in the list of charts.
search area line chart in excel
  • Select the sheet holding your data and click the Create Chart From Selection button, as shown below.
create chart from selection 080
  • To make changes to the Area Line Chart, click the Edit Chart.
edit time series chart in excel
  • Once the Chart Header Properties window pops up, click the Line 1 box and fill in your title.
  • Toggle the small button on the bottom right of the Line 2 box to the right side.
add header time series chart in excel
  • Click the Apply button to save the changes.
  • Click the Save Changes button to finish the editing task.
  • Check out the final Time Series Chart in Excel below.
time series graph excel

In the coming section, we’ll address the components of a Time Series Chart in Excel.

When To Avoid Using a Time Series Graph?

  • Irregular Time Intervals: If the data points are not collected at regular intervals, a time series graph may misrepresent trends and patterns.
  • Non-Temporal Data: When the data isn’t inherently tied to time, other types of charts like bar or scatter plots might be more appropriate.
  • Too Few Data Points: With a small number of data points, the graph may not provide meaningful insights or might exaggerate random fluctuations.
  • Complex Data Relationships: If the relationship between variables is complex or involves multiple dimensions, other visualization methods like scatter plots or heat maps may be more effective.

In the coming section, we’ll address the following question: why should you use the Time Series Chart?

FAQs:

What chart is best for displaying time series?

There are 4 key charts you can use to display time series insights. They include:

  1. Area Line Chart
  2. Dual Axis Line Chart
  3. Multi-Axis Line Chart
  4. Sentiment Trend Chart

The charts mentioned above are straightforward to read and interpret. Besides, they’re easy to plot if you use third-party add-ins, such as ChartExpo.

Wrap Up

You have data you’ve been tracking over time.

And you’re tasked to explain its trend and, most importantly, provide a forecast.

What’s the go-to chart?

Yes, you guessed right. It’s the Time Series Chart. The chart is suitable in this scenario because time and dates are continuous, categorical data.

If you want to craft a compelling data story that provides actionable insights into trends, outliers, and other shifts, use Time Series charts. And this is because they’re straightforward to read and understand. Remember, simplicity is always at the core of every persuasive narrative.

There’s no doubt that a majority of us don’t like to be subjected to cognitive overload. So, the simpler the message, the more compelling it becomes.

Excel lacks ready-to-use Time Series Charts.

So, what’s the solution?

We recommend you install third-party apps, such as ChartExpo, to access the ready-to-use Time Series Chart in Excel.

ChartExpo is an add-in for Excel that’s loaded with insightful and ready-to-go Time Series Graphs, such as Area Line Chart. You don’t need programming or coding skills to use ChartExpo.

Sign up for a 7-day free trial today to access ready-made Time Series Charts that are easy to interpret and visually appealing to your target audience.

How much did you enjoy this article?

ExcelAd1
Start Free Trial!
120357

Related articles

next previous
Microsoft Excel10 min read

Invoice Tracker Template in Excel for Better Insights

An invoice tracker Excel template helps track invoices, due dates, and payments. Learn how to use this template for better financial management.

Microsoft Excel12 min read

Key Performance Indicators in Healthcare for Better Insights

Key Performance Indicators in healthcare track patient care and efficiency. Learn about these KPIs, top examples, and how to use them to improve outcomes.

Microsoft Excel10 min read

BMI Calculation Formula in Excel for Better Fitness Insights

The BMI calculation formula in Excel helps track and analyze body mass index. Explore step-by-step instructions and tips to simplify BMI tracking in Excel.

Microsoft Excel29 min read

How to Create a Tornado Chart in Excel? A Complete Guide

Click to learn how to plot a Tornado Chart in Excel using easy-to-follow steps. Also, we’ll address the following question: what is a Tornado Diagram?

Microsoft Excel14 min read

How to Create a Scatter Plot in Excel with 3 Variables?

Click to discover how to create a Scatter Plot in Excel with 3 variables. We’ll also address the following question: why do we use Scatter Plot Graph?

ChartExpo logo

Turn Data into Visual
Stories

CHARTEXPO

  • Home
  • Gallery
  • Videos
  • Services
  • Pricing
  • Contact us
  • FAQs
  • Privacy policy
  • Terms of Service
  • Sitemap

TOOLS

  • ChartExpo for Google Sheets
  • ChartExpo for Microsoft Excel
  • Power BI Custom Visuals by ChartExpo
  • Word Cloud

CATEGORIES

  • Bar Charts
  • Circle Graphs
  • Column Charts
  • Combo Charts
  • Comparison Charts
  • Line Graphs
  • PPC Charts
  • Sentiment Analysis Charts
  • Survey Charts

TOP CHARTS

  • Sankey Diagram
  • Likert Scale Chart
  • Comparison Bar Chart
  • Pareto Chart
  • Funnel Chart
  • Gauge Chart
  • Radar Chart
  • Radial Bar Chart
  • Sunburst Chart
  • see more
  • Scatter Plot Chart
  • CSAT Survey Bar Chart
  • CSAT Survey Chart
  • Dot Plot Chart
  • Double Bar Graph
  • Matrix Chart
  • Multi Axis Line Chart
  • Overlapping Bar Chart
  • Control Chart
  • Slope Chart
  • Clustered Bar Chart
  • Clustered Column Chart
  • Box and Whisker Plot
  • Tornado Chart
  • Waterfall Chart
  • Word Cloud
  • see less

RESOURCES

  • Blog
  • Resources
  • YouTube
SIGN UP FOR UPDATES

We wouldn't dream of spamming you or selling your info.

© 2025 ChartExpo, all rights reserved.