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
Andy
Brad wrote:
> 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.)

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks andy ... I knew it could be done, just didn¹t think to look there!

in article (E-Mail Removed), Andy Pope at
(E-Mail Removed) wrote on 30/3/04 6:58 PM:

> Hi Brad,
>
> Select the chart and then use the menu Tools > Options.
> On the chart tab is a Plot Empty cells as: Interpolated.
>
> Cheers
> Andy
> Brad wrote:
>> > 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.)