Line Charts in PPTX Template

Learn how to create and populate line charts in your PowerPoint templates to show trends over time.

Overview

Line charts display data as a series of points connected by lines, making them ideal for showing trends, changes over time, and relationships between data points.

Generation only works when the source table and the placeholder chart are set up as described below. Full rules: Charts in PPTX Template.

Worked examples with sample files:

Data Structure

Line charts require:

  • Categories: Row labels, typically time periods or ordered categories (X-axis), for example months of the year
  • Series: Columns, for example lead channels or regions
  • Values: Cells at the intersection of category and series (Y-axis)

If categories are currently columns in Excel, transpose the range (copy → Paste Special → Transpose), then create a named table (Ctrl+T).

Example Data

{
  "chart_title": "Sales by Region",
  "data": [
    {
      "month": "January",
      "north": 45000,
      "south": 38000,
      "east": 52000,
      "west": 41000
    },
    {
      "month": "February",
      "north": 48000,
      "south": 40000,
      "east": 55000,
      "west": 43000
    },
    {
      "month": "March",
      "north": 52000,
      "south": 42000,
      "east": 58000,
      "west": 45000
    }
  ]
}

Tabular representation (as it appears in Excel):

Month North South East West
January 45,000 38,000 52,000 41,000
February 48,000 40,000 55,000 43,000
March 52,000 42,000 58,000 45,000

Creating a Line Chart Template

The placeholder chart must be set up specifically, or dummy series stay in the generated file.

  1. Prepare the data: Categories as row labels, series as columns, values in cells. Transpose in Excel if needed, then format as a named table (Ctrl+T).
  2. Insert Chart: In PowerPoint, go to Insert > Chart > Line Chart
  3. Choose Line Chart Type: Select a line chart variant (line, line with markers, etc.). The type you insert is the type you get after merge.
  4. Keep only the first series: Right-click the chart → Edit Data and delete every series column except the first. Extra dummy series are not overwritten. If the chart has more series than your table, leftover dummy series stay untouched.
  5. Apply Formatting: Style the chart as desired (colors, line styles, markers). Additional series from your table are created from this first series.
  6. Add Placeholders: Use placeholders in chart titles if needed
  7. Link data to the chart: Right-click the dummy chart → View Alt Text. Set the Description field to:
  • For JSON data: {{type=chart data=json.data}} (assuming the JSON structure as in the example above)
  • For Excel data: {{type=chart data=xlsx.SheetName!TableName}} (sheet name and table name must match the workbook)

Example Excel reference:

{{type=chart data=xlsx.Sheet1!SalesData}}

Data Format

Simple Line Chart

For a single series line chart:

{
  "data": [
    {
      "quarter": "Q1",
      "value": 100
    },
    {
      "quarter": "Q2",
      "value": 150
    },
    {
      "quarter": "Q3",
      "value": 120
    },
    {
      "quarter": "Q4",
      "value": 180
    }
  ]
}

Multiple Series Line Chart

For comparing multiple trends. Each object is a category (a row). Remaining properties are series (columns):

{
  "data": [
    {
      "product": "Product A",
      "value2024": 1000,
      "value2025": 1100
    },
    {
      "product": "Product B",
      "value2024": 1500,
      "value2025": 1600
    },
    {
      "product": "Product C",
      "value2024": 1200,
      "value2025": 1300
    }
  ]
}

Best Practices

1. Time Series Data

Line charts work best with:

  • Time-based data (dates, months, quarters, years)
  • Ordered sequences
  • Continuous data points

2. Data Points

  • Ensure data points are in chronological order
  • Use consistent time intervals when possible
  • Handle missing data points appropriately

3. Line Styling

  • Use different line styles for multiple series
  • Consider using markers to highlight data points
  • Use colors that are easily distinguishable

4. Chart Title

  • Use descriptive chart titles
  • Consider using placeholders for dynamic titles: {{metric_name}} Trend

Common Use Cases

Sales Trends

Show sales performance over time periods.

Performance Metrics

Display KPIs, growth rates, or other metrics over time.

Comparison Trends

Compare multiple data series over the same time period.

Forecasting

Show historical data and projected trends.

Formatting Tips

Line Styles

  • Use solid lines for primary data
  • Use dashed or dotted lines for projections or secondary data
  • Adjust line thickness for emphasis

Markers

  • Add markers to highlight data points
  • Use different marker styles for different series
  • Consider marker size for readability

Axis Labels

  • Add clear axis labels
  • Format dates appropriately
  • Include units where necessary

Gridlines

  • Use horizontal gridlines for easier value reading
  • Keep gridlines subtle
  • Consider using major gridlines only

Troubleshooting

Dummy series still visible after generate

  • Delete all but the first series in the placeholder chart’s Edit Data view. Extra dummy series are not overwritten.
  • If the chart has more series than the table, leftover placeholder series stay as sample data.

Lines Not Displaying

  • Data orientation: Categories must be row labels, series must be columns. Transpose in Excel if they are swapped, then Ctrl+T and name the table.
  • Check Data Format: Ensure values are numbers, not strings
  • Verify Structure: Ensure categories and values arrays match
  • Check Chart Type: Verify you're using a line chart

Incorrect Trends

  • Data Order: Ensure data is in chronological order
  • Data Type: Verify numerical values are actual numbers
  • Missing Data: Check for null or undefined values

Formatting Issues

  • Chart formatting from template is preserved
  • Line styles and markers may need adjustment
  • Test with sample data to verify appearance

For more information, see Charts Overview or Basic Placeholders.

Worked examples with sample Excel and PowerPoint files: