Line Graph is turning into Dot Graph

[rmoralesaramburu]

Hello

I am trying to program a line graph and it is turning into a dot line. I suppose it is because of the NA values, but is there a way to handle it?

I am attaching the .prg and .wf1 file.

Thanks.

[EViews Gareth]

Add:

Code: Select all

posi.options connect

[EViews Gareth]

As an aside, you're probably better off using this wfopen command (which should mean you won't need the connect option):

Code: Select all

wfopen(page=posi) "H:\4. Benchmarking y Optimización\Set del Morning Meeting\Variaciones Boletín.xlsx" byrow range=cambios!f13 @freq w(mon) @id @date(date)

[rmoralesaramburu]

Thanks, the first solution worked out perfectly.

The second solution I am getting this error:

"Date is not defined in "wfopen(page=posi) "H:\4. Benchmarking y Optimización\Set del Morning Meeting\Variaciones Boletín.xlsx" byrow range=cambios!f13 @freq w(mon) @id @date(date)"