Can I join the dots?

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

If I have a series over time with data for only some points e.g.

Q1 2 - 1
Q2 2 - 3
Q3 2 - 5
Q4 2 ­ NO DATA
Q1 3 - 25
Q2 3 - 49
Q3 3 ­ NO DATA
Q4 3 - 200
Q1 4 ­ NO DATA
Q2 4 - 1000
Q3 4 ­ NO DATA
Q4 4 ­ 2000

How can I plot it with a line joining all the points? When I try, it only
joins consecutive data points and won¹t just ³skip² the NO DATA entries. (I
haven¹t actually written no data ...)

Cheers,

Brad.)
 
Hi Brad,

Select the chart and then use the menu Tools > Options.
On the chart tab is a Plot Empty cells as: Interpolated.

Cheers
 
Back
Top