Re: Broken Lines in Line Graph

Hi Natalie,

Instead of 'N/A' use the function =NA()
This will cause the chart to join between the valid dots.

Or if the cells are empty set teh Plot Empty cells as Interpolated.
To do this select the chart and then use the menus Tools > Options and
on the chart tab is the Plot Empty Cells options.

Natalie wrote:
> Hi everyone
>
> I have data which in some sections is broken. For example:
> W1 W2 W3 W4 W5 W6
> X 98 89 50 75
> Y 85 87 75 65
> (Some weeks data was obtained from a different venue).
>
> My problem is when constructing a line graph or scatter
> graph with lines, just the individual markers appear, no
> clean line unless there is consecutive data in the X or
> rows (for example there would be markers and a line for
> the X range for W1-W3 and just a marker for W5).
>
> I dont want to put in a 'N/A' or 0 as this causes it to
> return to 0 on the x axis each time - taking the overall
> shape out of the graph.
>
> As I am comparing Weeks 1-52 at various venues, I would
> like a line between all values even though there is no
> actual data.
>
> Does anyone have an idea how to do this? Any help would
> be greatly appreciated. I have Excel 97.
>
> Thanks
> Natalie

--

Cheers
Andy

http://www.andypope.info

Thanks Andy!
Greatly appreciated.
Natalie
>-----Original Message-----
>Hi Natalie,
>
>Instead of 'N/A' use the function =NA()
>This will cause the chart to join between the valid dots.
>
>Or if the cells are empty set teh Plot Empty cells as
Interpolated.
>To do this select the chart and then use the menus Tools
> Options and
>on the chart tab is the Plot Empty Cells options.
>
>Natalie wrote:
>> Hi everyone
>>
>> I have data which in some sections is broken. For
example:
>> W1 W2 W3 W4 W5 W6
>> X 98 89 50 75
>> Y 85 87 75 65
>> (Some weeks data was obtained from a different venue).
>>
>> My problem is when constructing a line graph or
scatter
>> graph with lines, just the individual markers appear,
no
>> clean line unless there is consecutive data in the X
or
>> rows (for example there would be markers and a line
for
>> the X range for W1-W3 and just a marker for W5).
>>
>> I dont want to put in a 'N/A' or 0 as this causes it
to
>> return to 0 on the x axis each time - taking the
overall
>> shape out of the graph.
>>
>> As I am comparing Weeks 1-52 at various venues, I
would
>> like a line between all values even though there is no
>> actual data.
>>
>> Does anyone have an idea how to do this? Any help
would
>> be greatly appreciated. I have Excel 97.
>>
>> Thanks
>> Natalie
>
>--
>
>Cheers
>Andy
>
>http://www.andypope.info
>
>.
>