Results 1 to 3 of 3

Line Charts - How to cope with missing values

This is a discussion on Line Charts - How to cope with missing values within the Excel Questions forums, part of the Question Forums category; I'm trying to create a time series line chart over 20years. But some for some of the years the data ...

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2

    Default

    I'm trying to create a time series line chart over 20years. But some for some of the years the data is missing and Excel refuses to join it up. How do I make it? Doing 'hide' joins it up but also gets rid of the years and I need to retain the scale of the graph.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    On 2002-03-21 11:26, Kate wrote:
    I'm trying to create a time series line chart over 20years. But some for some of the years the data is missing and Excel refuses to join it up. How do I make it? Doing 'hide' joins it up but also gets rid of the years and I need to retain the scale of the graph.
    If by "join it up" you mean interpolate, and if the missing data is represented by empty cells after selecting the chart choose the Tools | Options... menu command and click on
    the "Plot empty cells as: Interpolated" option located on the Chart tab.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2

    Default

    thanks.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com