Possible to create line chart with values not in all time periods?
 

Is it possible to create a chart with lines connecting the values on a time
axis where there are NOT data points for each time period? For example, 30
days over which only 5 values occur.

When I tried to add a line to a scatter chart nothing happened. I suppose I
could create another series that uses the end points of the first series and
simply fills in the values based on the slope between the two points but I'm
hoping there is a better way.

Many thanks for your assistance.

Possible to create line chart with values not in all time periods?
 

Go to Tools Options Chart tab, and choose the Interpolate option for how
to treat blank cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"CodeKid" wrote in message
...
Is it possible to create a chart with lines connecting the values on a
time
axis where there are NOT data points for each time period? For example, 30
days over which only 5 values occur.

When I tried to add a line to a scatter chart nothing happened. I suppose
I
could create another series that uses the end points of the first series
and
simply fills in the values based on the slope between the two points but
I'm
hoping there is a better way.

Many thanks for your assistance.